[ https://issues.apache.org/jira/browse/HIVE-4073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13589989#comment-13589989 ]
Ashutosh Chauhan commented on HIVE-4073: ---------------------------------------- No this query shouldn't be allowed. Should raise an exception. Comments says queries which has windowing in those cases we can do this. But query in question clearly has no windowing spec. It will be good to force number of reducers to 1, else it will be wastage of resources. But is probably fine to do later since this empty over clause is kind of a corner case anyways. > Make partition by optional in over clause > ----------------------------------------- > > Key: HIVE-4073 > URL: https://issues.apache.org/jira/browse/HIVE-4073 > Project: Hive > Issue Type: Bug > Components: PTF-Windowing > Reporter: Ashutosh Chauhan > Assignee: Brock Noland > Attachments: HIVE-4073-0.patch, HIVE-4073-1.patch > > > select s, sum( i ) over() from tt; should work. -- 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