[
https://issues.apache.org/jira/browse/HIVE-4028?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13579701#comment-13579701
]
Harish Butani commented on HIVE-4028:
-------------------------------------
+1
you mean this worked:
{noformat}
select max(i) over (w) from over100k window w as partition by f;
{noformat}
Remember putting the parenthesis because there was an ambiguity, don't remember
what it was;
I checked now with your changes, there is no ambiguity
> Bring paranthesis handling in windowing specification in compliance with sql
> standard
> -------------------------------------------------------------------------------------
>
> Key: HIVE-4028
> URL: https://issues.apache.org/jira/browse/HIVE-4028
> Project: Hive
> Issue Type: Bug
> Components: PTF-Windowing
> Reporter: Ashutosh Chauhan
> Assignee: Ashutosh Chauhan
> Attachments: hive-4028.patch
>
>
> {noformat}
> select max(i) over w from over100k window w as (partition by f);
> {noformat}
> is sql compliant but doesn't work, but following does work:
> {noformat}
> select max(i) over w from over100k window (w) as partition by f;
> {noformat}
> We should make sure standard compliant sql works.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
