Bigdata SQL: Table Sizing

CBO relies heavily on the statistics present in the Hive metastore for the table and columns to make the best query execution plans. These statistics include row counts,
column distinct values, boundary statistics, and data distribution metrics. This helps the optimizer decide the type of algorithm to apply, based on whether the full table can be
cached in-memory or the query processing requires swapping of the data to disk.