Question

Why aren't partition key enabled for Impala?

  • 7 December 2021
  • 1 reply
  • 27 views

Userlevel 1

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?


This topic has been closed for comments

1 reply

Userlevel 4

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-Optimization

Hope this helps