[HIVE-3073] Hive List Bucketing - DML support

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.10.0
• Fix Version/s: 0.11.0
• Component/s: SQL
• Labels: TODOC11
• Hadoop Flags: Reviewed
• Assignee: Gang Tim Liu
• Reporter: Gang Tim Liu
• Created: 31/May/12 18:56
• Updated: 15/Jun/14 04:47
• Resolved: 05/Dec/12 11:58

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 DML change for the feature:
1. single skewed column
2. manual load data

Issue Links

• is related to: HIVE-3734 Static partition DML create duplicate files and records
• is related to: HIVE-3451 map-reduce jobs does not work for a partition containing sub-directories
• is related to: HIVE-3026 List Bucketing in Hive
• is related to: HIVE-3072 Hive List Bucketing - DDL support
• is related to: HIVE-3649 Hive List Bucketing - enhance DDL to specify list bucketing table
• is related to: HIVE-3601 Hive List Bucketing - add Skewed Information to "explain extended insert overwrite"
• is related to: HIVE-3650 Hive List Bucketing - validation
• relates to: HIVE-3554 Hive List Bucketing - Query logic