[ https://issues.apache.org/jira/browse/HIVE-12474?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Aaron Tokhy updated HIVE-12474: ------------------------------- Description: 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 is related to changes that were made as a part of HIVE-6617 was: 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; > 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 is related to changes that were made as a part of HIVE-6617 -- This message was sent by Atlassian JIRA (v6.3.4#6332)