Support Questions
Find answers, ask questions, and share your expertise

How to check whether Hive table CBO status?

Contributor

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;
1 ACCEPTED SOLUTION

Accepted Solutions

Re: How to check whether Hive table CBO status?

New Contributor

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

View solution in original post

2 REPLIES 2

Re: How to check whether Hive table CBO status?

New Contributor

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

View solution in original post

Re: How to check whether Hive table CBO status?

@rxu

and Its ok run compute stats anytime except peak hours.