Daniel Dai created HIVE-18189: --------------------------------- Summary: Order by position does not work when cbo is disabled Key: HIVE-18189 URL: https://issues.apache.org/jira/browse/HIVE-18189 Project: Hive Issue Type: Bug Components: Query Planning Reporter: Daniel Dai Assignee: Daniel Dai
Investigating a failed query: {code} set hive.cbo.enable=false; set hive.orderby.position.alias=true; select distinct age from student order by 1 desc limit 20; {code} 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 -- This message was sent by Atlassian JIRA (v6.4.14#64029)