Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

How to check whether Hive table CBO status?

avatar
Rising Star

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

avatar
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

avatar
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

avatar
Master Mentor

@rxu

and Its ok run compute stats anytime except peak hours.