[
https://issues.apache.org/jira/browse/HIVE-4081?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13594147#comment-13594147
]
Ashutosh Chauhan commented on HIVE-4081:
----------------------------------------
Also it will be good to add following tests using newly added over10k dataset.
{noformat}
select s, si - lead(f, 3) over (partition by t order by bo desc) from over10k
limit 100;
select s, i - lead(i, 3, 0) over (partition by si order by i) from over10k
limit 100;
select s, si - lag(d, 3) over (partition by b order by si) from over10k limit
100;
select s, lag(s, 3, 'fred') over (partition by f order by b) from over10k limit
100;
{noformat}
> allow expressions with over clause
> ----------------------------------
>
> Key: HIVE-4081
> URL: https://issues.apache.org/jira/browse/HIVE-4081
> Project: Hive
> Issue Type: Bug
> Components: PTF-Windowing
> Reporter: Harish Butani
> Assignee: Harish Butani
> Attachments: HIVE-4081.D9063.1.patch
>
>
> remove current restriction where only a UDAF invocation is allowed with a
> windowing specification
--
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
