[ https://issues.apache.org/jira/browse/HIVE-18189?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Daniel Dai reassigned HIVE-18189: --------------------------------- > 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)