[
https://issues.apache.org/jira/browse/HIVE-16527?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15989836#comment-15989836
]
Hive QA commented on HIVE-16527:
--------------------------------
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12865594/HIVE-16527.03.patch
{color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified.
{color:red}ERROR:{color} -1 due to 4 failed/errored test(s), 10631 tests
executed
*Failed tests:*
{noformat}
TestHs2Hooks - did not produce a TEST-*.xml file (likely timed out)
(batchId=214)
org.apache.hadoop.hive.cli.TestAccumuloCliDriver.testCliDriver[accumulo_index]
(batchId=225)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_if_expr]
(batchId=143)
org.apache.hadoop.hive.cli.TestSparkNegativeCliDriver.org.apache.hadoop.hive.cli.TestSparkNegativeCliDriver
(batchId=236)
{noformat}
Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/4941/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/4941/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-4941/
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: 4 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12865594 - 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, HIVE-16527.02.patch,
> HIVE-16527.03.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)
