hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel Dai (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-18189) Order by position does not work when cbo is disabled
Date Tue, 05 Dec 2017 21:46:01 GMT

    [ https://issues.apache.org/jira/browse/HIVE-18189?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16279230#comment-16279230
] 

Daniel Dai commented on HIVE-18189:
-----------------------------------

named_column_join.q and named_column_join.q pass locally. Tests are clear.

> 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
>         Attachments: HIVE-18189.1.patch, HIVE-18189.2.patch, HIVE-18189.3.patch
>
>
> 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)

Mime
View raw message