hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Harish Butani (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-4112) Window range specification should be more flexible
Date Thu, 07 Mar 2013 00:44:12 GMT

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

Harish Butani commented on HIVE-4112:
-------------------------------------

It was done to highlight that the range based window is based on column values and not on
the number of rows. Can easily change the syntax to use preceding and following. 
The semantics are: form a window by going backwards(or forwards) until it reaches a row whose
difference in value with the 'current' row is more than the value specified in the query.
 Only works for numeric types + timestamp. So 'less' and 'more' seemed a more natural way
to express this.
Haven't looked at supporting the interval syntax in Oracle.
                
> Window range specification should be more flexible
> --------------------------------------------------
>
>                 Key: HIVE-4112
>                 URL: https://issues.apache.org/jira/browse/HIVE-4112
>             Project: Hive
>          Issue Type: Bug
>          Components: PTF-Windowing
>            Reporter: Ashutosh Chauhan
>
> select s, avg(f) over (partition by dec order by d rows 5 preceding) from over100k;
> is a legal query which is currently rejected by Parser.

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