[ 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