Alan Gates created HIVE-4190:
--------------------------------

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