Remus Rusanu created HIVE-16527:
-----------------------------------
Summary: Support outer and mixed reference aggregates in windowed
functions
Key: HIVE-16527
URL: https://issues.apache.org/jira/browse/HIVE-16527
Project: Hive
Issue Type: Improvement
Components: Query Processor
Reporter: Remus Rusanu
Assignee: Remus Rusanu
{noformat}
select sum(sum(c1)) over() from e011_01;
select sum(sum(c1)) over(partition by c2 order by c1) from e011_01 group by
e011_01.c1, e011_01.c2;
select sum(sum(e011_01.c1)) over(partition by e011_01.c2 order by e011_01.c1)
from e011_01 join e011_03 on e011_01.c1 = e011_03.c1 group by e011_01.c1,
e011_01.c2;
select sum(sum(e011_01.c1)) over(partition by e011_03.c2 order by e011_03.c1)
from e011_01 join e011_03 on e011_01.c1 = e011_03.c1 group by e011_03.c1,
e011_03.c2;
select sum(corr(e011_01.c1, e011_03.c1)) over(partition by e011_01.c2 order by
e011_03.c2) from e011_01 join e011_03 on e011_01.c1 = e011_03.c1 group by
e011_03.c2, e011_01.c2;
{noformat}
We fail to generate a plan for any of the above. The issue is that in
{{SemanticAnalyzer.doPhase1GetAllAggregations}}, for {{TOK_WINDOWSPEC}} we
ignore all children except the last (the window spec child). Additionally the
typecheck processor is not prepared to encounter UDAF expressions
({{TypeCheckProcFactory.DefaultExpreProcessor.validateUDF}},
{{getXpathOrFuncExprNodeDesc}}).
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
