[HIVE-33] [Hive]: Add optimizer statistics in Hive

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Component/s: Query Processor, Statistics
• Labels: statistics
• Assignee: Unassigned
• Reporter: Ashish Thusoo
• Created: 22/Oct/08 18:41
• Updated: 05/Jul/17 14:29
• Resolved: 05/Jul/17 14:29

Description

Add commands to collect partition and column level statistics in hive.

Issue Links

• incorporates: HIVE-1361 table/partition level statistics
• incorporates: HIVE-1362 Optimizer statistics on columns in tables and partitions
• relates to: HIVE-2472 Metastore statistics are not being updated for CTAS queries.
• relates to: HIVE-1940 Query Optimization Using Column Statistics and Histograms
• relates to: HIVE-3027 The optimizer architecture of Hive is terrible, need code refactoring
• relates to: HIVE-1938 Cost Based Query optimization for Joins in Hive
• relates to: HIVE-3917 Support noscan operation for analyze command

Sub-Tasks

• Optimizer statistics on columns in tables and partitions: Closed
• table/partition level statistics: Closed
• Automatically gathering statistics when reading a table/partition: Open