I have a parquet table named 'cats' holding 2 columns (day STRING, number INT). Statistics are generated both for the table and the 2 columns (e.g. max, min, distinct can be seen in DESCRIBE FORMATTED default.cats number). Still, when running an explain command for a select max, it looks like the statistics aren't being used. Why is this? How can Hive be configured to use the stats? All the following settings are true: set hive.cbo.enable; set hive.stats.autogather; set hive.compute.query.using.stats; set hive.stats.fetch.column.stats; set hive.stats.fetch.partition.stats; explain select max(number) from default.cats;
... View more
