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

Ashutosh Chauhan resolved HIVE-4190.
------------------------------------

    Resolution: Fixed

This patch is subsumed in HIVE-4197 which is now fixed.
                
> OVER clauses with ORDER BY not getting windowing set properly
> -------------------------------------------------------------
>
>                 Key: HIVE-4190
>                 URL: https://issues.apache.org/jira/browse/HIVE-4190
>             Project: Hive
>          Issue Type: Bug
>          Components: PTF-Windowing
>    Affects Versions: 0.11.0
>            Reporter: Alan Gates
>
> Given a query like:
> select s, avg(f) over (partition by si order by d) from over100k;
> Hive is not setting the window frame properly.  The order by creates an 
> implicit window frame of 'unbounded preceding' but Hive is treating the above 
> query as if it has no window.

--
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