[
https://issues.apache.org/jira/browse/HIVE-4192?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13604753#comment-13604753
]
Harish Butani commented on HIVE-4192:
-------------------------------------
Yes in our implementation we disallow Window Frames on rank, dense_rank,
cume_dist, percent_rank, lead and lag. Didn't make sense to allow a Window
Frame on these. This is documented in Jira 4197. Should be fixed/resolved by
Jira 4197.
> Use of LEAD in an OVER clauses causes the query to fail
> -------------------------------------------------------
>
> Key: HIVE-4192
> URL: https://issues.apache.org/jira/browse/HIVE-4192
> Project: Hive
> Issue Type: Bug
> Components: PTF-Windowing
> Affects Versions: 0.11.0
> Reporter: Alan Gates
>
> Running a query like:
> {code}
> select i, lead(s) over (partition by bin order by d desc
> rows between current row and 1 following)
> from over100k;
> {code}
> gives an error:
> {code}
> FAILED: SemanticException Function lead((TOK_TABLE_OR_COL s))
> org.apache.hadoop.hive.ql.parse.WindowingSpec$WindowSpec@13e15f7 as _wcol0
> doesn't support windowing
> {code}
--
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
