You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Rui Li (JIRA)" <ji...@apache.org> on 2013/11/15 08:33:20 UTC

[jira] [Created] (HIVE-5831) filter input files for bucketed tables

Rui Li created HIVE-5831:
----------------------------

             Summary: filter input files for bucketed tables
                 Key: HIVE-5831
                 URL: https://issues.apache.org/jira/browse/HIVE-5831
             Project: Hive
          Issue Type: Improvement
          Components: Query Processor
            Reporter: Rui Li


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;



--
This message was sent by Atlassian JIRA
(v6.1#6144)