hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alan Gates (JIRA)" <>
Subject [jira] [Commented] (HIVE-4112) Window range specification should be more flexible
Date Wed, 06 Mar 2013 22:56:13 GMT


Alan Gates commented on HIVE-4112:

I'm curious why you're proposing different keywords for use with RANGE than ROWS.  As far
as I can tell both Oracle and the ANSI standard propose using PRECEDING and FOLLOWING in both
> Window range specification should be more flexible
> --------------------------------------------------
>                 Key: HIVE-4112
>                 URL:
>             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:

View raw message