[HIVE-19113] Bucketing: Make CLUSTERED BY do CLUSTER BY if no explicit sorting is specified

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 4.0.0-alpha-1
• Component/s: Logical Optimizer
• Labels: pull-request-available
• Assignee: Jesús Camacho Rodríguez
• Reporter: Gopal Vijayaraghavan
• Created: 04/Apr/18 23:40
• Updated: 27/Feb/24 22:24
• Resolved: 24/Jul/19 14:13

Description

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.

Issue Links

• links to: GitHub Pull Request #731