[jira] Created: (HIVE-252) Automatically add CLUSTER BY and set the number of reducers if the target table is declared with "CLUSTERED BY (xxx) INTO yyy BUCKETS"

[Zheng Shao (JIRA)]

Automatically add CLUSTER BY and set the number of reducers if the target table 
is declared with "CLUSTERED BY (xxx) INTO yyy BUCKETS"
--------------------------------------------------------------------------------------------------------------------------------------

                 Key: HIVE-252
                 URL: https://issues.apache.org/jira/browse/HIVE-252
             Project: Hadoop Hive
          Issue Type: New Feature
          Components: Query Processor
            Reporter: Zheng Shao


We should automatically add a "cluster by" clause to the following query with 
64 reducers.

CREATE TABLE aaa (a BIGINT, b INT)
PARTITIONED BY(ds STRING)
CLUSTERED BY(a) INTO 64 BUCKETS 
STORED AS SEQUENCEFILE;

INSERT OVERWRITE TABLE aaa PARTITION(ds='2009-01-24')
SELECT a.a, a.b
FROM training_set a
WHERE a.ds = '2009-01-24';


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.