[HIVE-12474] ORDER BY should handle column refs in parantheses

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 1.0.0, 1.2.1
• Component/s: Parser
• Assignee: Xuefu Zhang
• Reporter: Aaron Tokhy
• Created: 19/Nov/15 23:48
• Updated: 23/Nov/15 23:43

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;

Issue Links

• is related to: HIVE-5607 Hive fails to parse the "%" (mod) sign after brackets.
• is related to: HIVE-6617 Reduce ambiguity in grammar