[HIVE-18189] Order by position does not work when cbo is disabled

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.0.0
• Component/s: Query Planning
• Target Version/s: 3.0.0
• Assignee: Daniel Dai
• Reporter: Daniel Dai
• Created: 30/Nov/17 23:00
• Updated: 22/May/18 23:16
• Resolved: 06/Dec/17 08:48

Description

Investigating a failed query:

set hive.cbo.enable=false;
set hive.orderby.position.alias=true;
select distinct age from student order by 1 desc limit 20;

The query does not sort the output correctly when cbo is disabled/inactivated. I found two issues:
1. "order by position" query is broken by HIVE-16774
2. In particular, select distinct query never work for "order by position" query