Gopal V created HIVE-19113:
------------------------------

             Summary: Bucketing: Make CLUSTERED BY do CLUSTER BY if no explicit 
sorting is specified
                 Key: HIVE-19113
                 URL: https://issues.apache.org/jira/browse/HIVE-19113
             Project: Hive
          Issue Type: Bug
          Components: Logical Optimizer
    Affects Versions: 3.0.0
            Reporter: Gopal V


The user's expectation of 

"create external table bucketed (key int) clustered by (key) into 4 buckets 
stored as orc;"

is that the table will cluster the key into 4 buckets, while the file layout 
does not do any actual clustering of rows.

In the absence of a "SORTED BY", this can automatically do a "SORTED BY (key)" 
to cluster the keys within the file as expected.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to