[ https://issues.apache.org/jira/browse/HIVE-19113?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jesus Camacho Rodriguez updated HIVE-19113: ------------------------------------------- Resolution: Fixed Fix Version/s: 4.0.0 Status: Resolved (was: Patch Available) > 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: Improvement > Components: Logical Optimizer > Affects Versions: 3.0.0 > Reporter: Gopal V > Assignee: Jesus Camacho Rodriguez > Priority: Major > Labels: pull-request-available > Fix For: 4.0.0 > > Attachments: HIVE-19113.01.patch, HIVE-19113.patch > > Time Spent: 1h 10m > Remaining Estimate: 0h > > 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.14#76016)