[HIVE-3072] Hive List Bucketing - DDL support

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.10.0
• Component/s: SQL
• Hadoop Flags: Reviewed

Release Note

This feature is incomplete and has been disabled until HIVE-3073 (DML support for list bucketing) is finished and committed.

• Assignee: Gang Tim Liu
• Reporter: Gang Tim Liu
• Created: 31/May/12 18:51
• Updated: 02/Jul/14 06:52
• Resolved: 25/Aug/12 02:44

Description

If a hive table column has skewed keys, query performance on non-skewed key is always impacted. Hive List Bucketing feature will address it:

https://cwiki.apache.org/Hive/listbucketing.html

This jira issue will track DDL change for the feature. It's for both single skewed column and multiple columns.

Issue Links

• is related to: HIVE-3497 Avoid NPE in skewed information read
• is related to: HIVE-3742 The derby metastore schema script for 0.10.0 doesn't run
• is related to: HIVE-3485 Hive List Bucketing - Skewed DDL doesn't support skewed value with string quote
• is related to: HIVE-3026 List Bucketing in Hive
• relates to: HIVE-3073 Hive List Bucketing - DML support
• relates to: HIVE-3554 Hive List Bucketing - Query logic
• relates to: HIVE-3649 Hive List Bucketing - enhance DDL to specify list bucketing table