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)