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;
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.