[ 
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

Reply via email to