hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sergey Shelukhin (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-18189) Order by position does not work when cbo is disabled
Date Fri, 01 Dec 2017 20:11:00 GMT

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

Sergey Shelukhin commented on HIVE-18189:
-----------------------------------------

The test appears to have failed. In general, looks good. One nit:
{noformat}
node = (ASTNode) colNode.getChild(0);
+            if (node != null
{noformat}
in a couple places; it seems like length needs to be checked before accessing the element
by index, and null check is unnecessary cause it will throw if it's absent right now.

> 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
>
>
> 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