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

How to check whether Hive table CBO status?

Solved Go to solution

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.