- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
How to check whether Hive table CBO status?
- Labels:
-
Apache Hive
Created 01-20-2016 10:10 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
- analyze table t compute statistics;
- analyze table t compute statistics for columns;
Created 01-21-2016 11:15 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Created 01-21-2016 11:15 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Created 01-22-2016 04:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
and Its ok run compute stats anytime except peak hours.