Column Statistics in Apache Impala

Along with the “Table Statistics”, the statistics about the table columns used by the Impala query planner. This post will show you how to retrieve and also how to update the column statistics.

SHOW COLUMN STATS empavro2;
SHOW COLUMN STATS Employee_Parquet2;
SHOW COLUMN STATS townslist;

ShowColumnStats

The results of the above column statistics were updated ones and in case not updated, use the below command to get the job done.

COMPUTE STATS empavro2;
COMPUTE STATS Employee_Parquet2;
COMPUTE STATS townslist;

Hope you find this article helpful.

Please keep in touch for more interesting updates.

One comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s