[
https://issues.apache.org/jira/browse/HIVE-16527?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15984030#comment-15984030
]
Hive QA commented on HIVE-16527:
--------------------------------
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12864974/HIVE-16527.00.patch
{color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified.
{color:red}ERROR:{color} -1 due to 5 failed/errored test(s), 10639 tests
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestAccumuloCliDriver.testCliDriver[accumulo_index]
(batchId=225)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[leadlag] (batchId=53)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[temp_table_windowing_expressions]
(batchId=60)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[windowing_expressions]
(batchId=52)
org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[dynamic_semijoin_user_level]
(batchId=140)
{noformat}
Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/4871/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/4871/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-4871/
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 5 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12864974 - PreCommit-HIVE-Build
> 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
> Attachments: HIVE-16527.00.patch
>
>
> {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)
