You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Harish Butani (JIRA)" <ji...@apache.org> on 2013/03/17 22:15:14 UTC

[jira] [Commented] (HIVE-4190) OVER clauses with ORDER BY not getting windowing set properly

    [ https://issues.apache.org/jira/browse/HIVE-4190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13604752#comment-13604752 ] 

Harish Butani commented on HIVE-4190:
-------------------------------------

Yes, this is one of the many differences in behavior in our implementation from the Standard.
Is documented in 4197. Should be covered by it.
                
> 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