1 Reply Latest reply on Nov 14, 2014 11:23 AM by diego.medrano

    Data Extraction Speed with Hive

    Okkar Kyaw

      I'm connecting Tableau Desktop 8.2 to Cloudera Hadoop HiveServer2 via Kerberos. I want to extract a subset of the data in Hive tables now and then but I find the extraction speed to be extremely slow. For a table of 300+ fields, 1 million rows took more than 5 hours.

       

      I have already looked at http://kb.tableausoftware.com/articles/knowledgebase/hadoop-hive-performance and set the pre-connection SQL parameters but this has not improved the time. Any other suggestion?