Why aren't partition key enabled for Impala?

Our instance uses Impala and recently we enabled PDTs to fasten report performance. However the PDT tables are themselves very slow as there are no way to index or partition. 

How do you recommend increasing performance for Impala PDTs?

0 1 107
1 REPLY 1

Hi @Ayvi, are you using Cloudera Impala? Unfortunately, the two parameters “partition_keys” and “indexes” are not yet support for this dialect. You could submit this suggestion to our product team directly by clicking ? at top right in your Looker instance → Got product idea? 

We have this general article on improving PDT performance: https://help.looker.com/hc/en-us/articles/360023742593-Identifying-and-Building-PDTs-for-Performance...

Hope this helps

Top Labels in this Space
Top Solution Authors