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)