Generating and viewing Apache Hive statistics in Cloudera Data Warehouse
You can use statistics to optimize queries for improved performance. The cost-based optimizer (CBO) also uses statistics to compare query plans and choose the best one. By viewing statistics instead of running a query, you can often get answers to your data questions faster.
This task shows how to generate different types of statistics about a table.