[SPARK-12577] better support of parentheses in partition by and order by clause of window function's over clause

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.0.0
• Component/s: SQL
• Assignee: L. C. Hsieh
• Reporter: Reynold Xin
• Created: 30/Dec/15 02:58
• Updated: 12/Jan/16 00:33
• Resolved: 09/Jan/16 05:48

Description

Right now, Hive's parser support

-- PASS
SELECT SUM(1) OVER (PARTITION BY a + 1 - b * c / d FROM src;
SELECT SUM(1) OVER (PARTITION BY (a + 1 - b * c / d) FROM src;

But, the following one is not accepted

-- FAIL
SELECT SUM(1) OVER (PARTITION BY (a) + 1 - b * c / d) FROM src;

We should fix it in our own parser.

Issue Links

• links to: [Github] Pull Request #10620 (viirya)