Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

compute stats partitioned tables

compute stats partitioned tables

Master Collaborator

Hi,

 is there any way to compute incremental stats on partitioned table, where I know just the upper level of the partition value?

 

For example:

Table XXX is partitoned by (Country, City)

I would like to do:

compute stats incremental  XXX partition( Country=US ) 

But the Impala forces me to enumerate all items, so all partition values should be set.

 

Thanks for the advice,

T.

 

4 REPLIES 4

Re: compute stats partitioned tables

Contributor

Hi

 

This is currently not supported and you'll need to specify a full partition spec for all the partitions you want to compute stats. However, we are currently working on changing that behavior (see https://issues.cloudera.org/browse/IMPALA-1570) for more details. 

 

Dimitris

Re: compute stats partitioned tables

Master Collaborator
Issue does not exist
The issue you are trying to view does not exist.

Re: compute stats partitioned tables

Contributor

It picks the ) as part of the url. Just remove it. 

 

Dimitris

Highlighted

Re: compute stats partitioned tables

Contributor

thx. it helped. I was looking for this answer :)

BTW, the link you provide is broken. Can you update it?

 

NVM, I read your reply and removed the `)` from URL. thx