[ https://issues.apache.org/jira/browse/HIVE-7870?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14114739#comment-14114739 ]
Hive QA commented on HIVE-7870: ------------------------------- {color:red}Overall{color}: -1 at least one tests failed Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12665158/HIVE-7870.2-spark.patch {color:red}ERROR:{color} -1 due to 33 failed/errored test(s), 6304 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_sample_islocalmode_hook org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_union_remove_spark_1 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_union_remove_spark_10 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_union_remove_spark_15 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_union_remove_spark_16 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_union_remove_spark_17 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_union_remove_spark_18 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_union_remove_spark_19 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_union_remove_spark_2 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_union_remove_spark_20 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_union_remove_spark_21 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_union_remove_spark_24 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_union_remove_spark_25 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_union_remove_spark_3 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_union_remove_spark_4 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_union_remove_spark_5 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_union_remove_spark_6 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_union_remove_spark_7 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_union_remove_spark_8 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_union_remove_spark_9 org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_dynpart_sort_opt_vectorization org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_fs_default_name2 org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_sample8 org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_union10 org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_union18 org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_union19 org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_union28 org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_union29 org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_union3 org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_union30 org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_union33 org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_union4 org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_union6 {noformat} Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-SPARK-Build/102/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-SPARK-Build/102/console Test logs: http://ec2-54-176-176-199.us-west-1.compute.amazonaws.com/logs/PreCommit-HIVE-SPARK-Build-102/ Messages: {noformat} 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: 33 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12665158 > Insert overwrite table query does not generate correct task plan [Spark > Branch] > ------------------------------------------------------------------------------- > > Key: HIVE-7870 > URL: https://issues.apache.org/jira/browse/HIVE-7870 > Project: Hive > Issue Type: Sub-task > Components: Spark > Reporter: Na Yang > Assignee: Na Yang > Labels: Spark-M1 > Attachments: HIVE-7870.1-spark.patch, HIVE-7870.2-spark.patch > > > Insert overwrite table query does not generate correct task plan when > hive.optimize.union.remove and hive.merge.sparkfiles properties are ON. > {noformat} > set hive.optimize.union.remove=true > set hive.merge.sparkfiles=true > insert overwrite table outputTbl1 > SELECT * FROM > ( > select key, 1 as values from inputTbl1 > union all > select * FROM ( > SELECT key, count(1) as values from inputTbl1 group by key > UNION ALL > SELECT key, 2 as values from inputTbl1 > ) a > )b; > select * from outputTbl1 order by key, values; > {noformat} > query result > {noformat} > 1 1 > 1 2 > 2 1 > 2 2 > 3 1 > 3 2 > 7 1 > 7 2 > 8 2 > 8 2 > 8 2 > {noformat} > expected result: > {noformat} > 1 1 > 1 1 > 1 2 > 2 1 > 2 1 > 2 2 > 3 1 > 3 1 > 3 2 > 7 1 > 7 1 > 7 2 > 8 1 > 8 1 > 8 2 > 8 2 > 8 2 > {noformat} > Move work is not working properly and some data are missing during move. -- This message was sent by Atlassian JIRA (v6.2#6252)