[jira] [Commented] (HIVE-20208) order by position alias do not work

[Vineet Garg (JIRA)]

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

Vineet Garg commented on HIVE-20208:
------------------------------------

[~xulongfetion] I tried on master with both CBO off and on but still not able 
to reproduce.
{code:sql}
hive> create table table1(a int, b int, c int);
OK
Time taken: 0.039 seconds

hive> set hive.cbo.enable=false;
hive> explain select a, b, c from table1 order by 1, 2;
OK
STAGE DEPENDENCIES:
  Stage-1 is a root stage
  Stage-0 depends on stages: Stage-1

STAGE PLANS:
  Stage: Stage-1
    Tez
      DagId: vgarg_20180720154819_7d0340fd-7214-41fc-a81d-990f88703153:5
      Edges:
        Reducer 2 <- Map 1 (SIMPLE_EDGE)
      DagName: vgarg_20180720154819_7d0340fd-7214-41fc-a81d-990f88703153:5
      Vertices:
        Map 1
...........
{code}

Can you provide full test case?


> order by position alias do not work
> -----------------------------------
>
>                 Key: HIVE-20208
>                 URL: https://issues.apache.org/jira/browse/HIVE-20208
>             Project: Hive
>          Issue Type: Bug
>          Components: Hive
>            Reporter: xulongfetion
>            Assignee: Vineet Garg
>            Priority: Blocker
>              Labels: patch-available
>         Attachments: HIVE-orderby-position-alias.patch
>
>
> the order by position alias do not work if there's more than one position 
> alias. For query like
> "select a, b, c from table1 order by 1, 2;", hive will report column not 
> found error.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)