hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pengcheng Xiong (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-12474) ORDER BY should handle column refs in parantheses
Date Fri, 20 Nov 2015 03:22:11 GMT

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

Pengcheng Xiong commented on HIVE-12474:
----------------------------------------

[~xuefuz], would you mind if I re-assign this to you? It seems that it is designed intentionally
by your patch in HIVE-5607. I assume that the only thing that you need to do is to update
the document for this. Thanks. :)

> ORDER BY should handle column refs in parantheses
> -------------------------------------------------
>
>                 Key: HIVE-12474
>                 URL: https://issues.apache.org/jira/browse/HIVE-12474
>             Project: Hive
>          Issue Type: Bug
>          Components: Parser
>    Affects Versions: 1.0.0, 1.2.1
>            Reporter: Aaron Tokhy
>            Assignee: Pengcheng Xiong
>            Priority: Minor
>
> CREATE TABLE test(a INT, b INT, c INT)
> COMMENT 'This is a test table';
> hive>
> select lead(c) over (order by (a,b)) from test limit 10;
> FAILED: ParseException line 1:31 missing ) at ',' near ')'
> line 1:34 missing EOF at ')' near ')'
> hive>
> select lead(c) over (order by a,b) from test limit 10;
> - Works as expected.
> It appears that 'cluster by'/'sort by'/'distribute by'/'partition by' allows this:
> https://github.com/apache/hive/blob/release-1.2.1/ql/src/java/org/apache/hadoop/hive/ql/parse/IdentifiersParser.g#L129
> For example, this syntax is still valid:
> select lead(c) over (sort by (a,b)) from test limit 10;



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message