[HIVE-5831] filter input files for bucketed tables

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Component/s: Query Processor
• Assignee: Unassigned
• Reporter: Rui Li
• Created: 15/Nov/13 07:31
• Updated: 02/May/17 02:09
• Resolved: 02/May/17 00:40

Description

When the users query a bucketed table and use the bucketed column in the predicate, only the buckets that satisfy the predicate need to be scanned, thus improving the performance.
Given a table test:
CREATE TABLE test (x INT, y STRING) CLUSTERED BY ( x ) INTO 10 BUCKETS;
The following query only has to scan bucket 5:
SELECT * FROM test WHERE x=5;

Issue Links

• duplicates: HIVE-11525 Bucket pruning
• is duplicated by: HIVE-4926 Queries which specify clustered-by keys as constants will still scan all buckets
• is related to: HIVE-1662 Add file pruning into Hive.