[
https://issues.apache.org/jira/browse/HIVE-4126?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13596061#comment-13596061
]
Ashutosh Chauhan commented on HIVE-4126:
----------------------------------------
Also, following query in leadlag.q also failed:
select p1.p_mfgr, p1.p_name,
p1.p_size, p1.p_size - lag(p1.p_size,1,p_size) as deltaSz
from part p1 join part p2 on p1.p_partkey = p2.p_partkey
distribute by p1.p_mfgr
sort by p1.p_name ;
FAILED: SemanticException org.apache.hadoop.hive.ql.parse.SemanticException:
Column p_size Found in more than One Tables/Subqueries
> remove support for lead/lag UDFs outside of UDAF args
> -----------------------------------------------------
>
> Key: HIVE-4126
> URL: https://issues.apache.org/jira/browse/HIVE-4126
> Project: Hive
> Issue Type: Bug
> Components: PTF-Windowing
> Reporter: Harish Butani
> Assignee: Harish Butani
> Attachments: HIVE-4126.D9105.1.patch
>
>
> Select Expressions such as
> p_size - lead(p_size,1)
> are currently handled as non aggregation expressions done after all over
> clauses are evaluated.
> Once we allow different partitions in a single select list(Jira 4041), these
> become ambiguous.
> - the equivalent way to do such things is either to use lead/lag UDAFs with
> expressions ( support added with Jira 4081)
> - stack windowing clauses with inline queries. select lead(r,1).. from
> (select rank() as r....)...
--
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
