[HIVE-171] distribute by and sort by ignored in the case of select *

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.3.0
• Component/s: Query Processor
• Hadoop Flags: Reviewed
• Release Note: Fixed select star with cluster by, distribute by and sort by.
• Assignee: Zheng Shao
• Reporter: Raghotham Murthy
• Created: 12/Dec/08 00:12
• Updated: 17/Dec/11 00:08
• Resolved: 23/Dec/08 21:54

Description

create table tab1(col1 string, col2 string)

select * from tab1 distribute by col1 sort by col2

is different from:

select col1, col2 from tab1 distribute by col1 sort by col2