[jira] [Resolved] (HIVE-4028) Bring paranthesis handling in windowing specification in compliance with sql standard

["Ashutosh Chauhan (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-4028?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ashutosh Chauhan resolved HIVE-4028.
------------------------------------

    Resolution: Fixed

Yeah thats correct. The query you had it is the one which worked. 
Patch checked in the branch.
                
> 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