[ https://issues.apache.org/jira/browse/HIVE-17617?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16197127#comment-16197127 ]
Hive QA commented on HIVE-17617: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12891055/HIVE-17617.04.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 6 failed/errored test(s), 11192 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[unionDistinct_1] (batchId=144) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[groupby_rollup_empty] (batchId=158) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[mergejoin] (batchId=159) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[optimize_nullscan] (batchId=162) org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver[spark_explainuser_1] (batchId=171) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query14] (batchId=239) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/7193/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/7193/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-7193/ 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: 6 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12891055 - PreCommit-HIVE-Build > Rollup of an empty resultset should contain the grouping of the empty > grouping set > ---------------------------------------------------------------------------------- > > Key: HIVE-17617 > URL: https://issues.apache.org/jira/browse/HIVE-17617 > Project: Hive > Issue Type: Sub-task > Components: SQL > Reporter: Zoltan Haindrich > Assignee: Zoltan Haindrich > Attachments: HIVE-17617.01.patch, HIVE-17617.03.patch, > HIVE-17617.04.patch > > > running > {code} > drop table if exists tx1; > create table tx1 (a integer,b integer,c integer); > select sum(c), > grouping(b) > from tx1 > group by rollup (b); > {code} > returns 0 rows; however > according to the standard: > The <empty grouping set> is regarded as the shortest such initial sublist. > For example, “ROLLUP ( (A, B), (C, D) )” > is equivalent to “GROUPING SETS ( (A, B, C, D), (A, B), () )”. > so I think the totals row (the grouping for {{()}} should be present) - psql > returns it. -- This message was sent by Atlassian JIRA (v6.4.14#64029)