hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alan Gates (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-4190) OVER clauses with ORDER BY not getting windowing set properly
Date Fri, 15 Mar 2013 21:50:13 GMT
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

Mime
View raw message