How to check whether Hive table CBO status?

[#1]

We suspect a Hive table CBO statistics is incorrect. How can we check it and how to re-compute them, should we run the commands again?

1. analyze table t compute statistics;
2. analyze table t compute statistics for columns;

[#2 · Accepted solution]

usually explain a query on the table or describe formatted on the table shows whether stats is 'accurate'. can also do describe formatted xxx column xxx; to have an idea if it is correct or not on the column

[#3]

@rxu

and Its ok run compute stats anytime except peak hours.