Support Questions
Find answers, ask questions, and share your expertise

improve tableau query time with kerberised Hadoop

improve tableau query time with kerberised Hadoop

Explorer

I have an external hive table in Hadoop with few partitioned key. For example, 10 columns and 2 partitioned key.

I was trying to pull data from Hadoop by using Tableau Hortonwork ODBC driver, the query time is very long.

Is there a way to enhance the performance in Hadoop/Tableau?

1 REPLY 1

Re: improve tableau query time with kerberised Hadoop

Hi @jeannie tan,

Without additional detail surrounding the data volumes, query types, and HDP versions I can't give very specific advice. However, there are quite a few general things you can do. Several are described on our blog including leveraging Tez, ORC files, CBO, and vectorization. Additionally, if you are running HDP 2.5 then you can leverage Hive 2.0 with LLAP which provides a caching layer to provide additional performance improvement.