[ https://issues.apache.org/jira/browse/HIVE-19191?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16446691#comment-16446691 ]
Hive QA commented on HIVE-19191: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12920002/HIVE-19191.01.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 29 failed/errored test(s), 14280 tests executed *Failed tests:* {noformat} TestMinimrCliDriver - did not produce a TEST-*.xml file (likely timed out) (batchId=93) [infer_bucket_sort_num_buckets.q,infer_bucket_sort_reducers_power_two.q,parallel_orderby.q,bucket_num_reducers_acid.q,infer_bucket_sort_map_operators.q,infer_bucket_sort_merge.q,root_dir_external_table.q,infer_bucket_sort_dyn_part.q,udf_using.q,bucket_num_reducers_acid2.q] TestNonCatCallsWithCatalog - did not produce a TEST-*.xml file (likely timed out) (batchId=217) org.apache.hadoop.hive.cli.TestBeeLineDriver.testCliDriver[materialized_view_create_rewrite] (batchId=253) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[insert_into6] (batchId=74) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[parquet_vectorization_0] (batchId=17) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[results_cache_invalidation2] (batchId=39) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[bucket_map_join_tez1] (batchId=175) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[materialized_view_create_rewrite] (batchId=154) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[materialized_view_create_rewrite_dummy] (batchId=167) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[results_cache_invalidation2] (batchId=163) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[sysdb] (batchId=163) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[tez_smb_1] (batchId=171) org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[explainanalyze_5] (batchId=105) org.apache.hadoop.hive.cli.TestNegativeMinimrCliDriver.testCliDriver[cluster_tasklog_retrieval] (batchId=98) org.apache.hadoop.hive.cli.TestNegativeMinimrCliDriver.testCliDriver[mapreduce_stack_trace] (batchId=98) org.apache.hadoop.hive.cli.TestNegativeMinimrCliDriver.testCliDriver[mapreduce_stack_trace_turnoff] (batchId=98) org.apache.hadoop.hive.cli.TestNegativeMinimrCliDriver.testCliDriver[minimr_broken_pipe] (batchId=98) org.apache.hadoop.hive.ql.TestAcidOnTez.testAcidInsertWithRemoveUnion (batchId=228) org.apache.hadoop.hive.ql.TestAcidOnTez.testCtasTezUnion (batchId=228) org.apache.hadoop.hive.ql.TestAcidOnTez.testNonStandardConversion01 (batchId=228) org.apache.hadoop.hive.ql.TestAutoPurgeTables.testAutoPurgeUnset (batchId=233) org.apache.hadoop.hive.ql.TestAutoPurgeTables.testTruncateNoAutoPurge (batchId=233) org.apache.hadoop.hive.ql.TestMTQueries.testMTQueries1 (batchId=232) org.apache.hive.beeline.TestBeeLineWithArgs.testQueryProgress (batchId=235) org.apache.hive.jdbc.TestSchedulerQueue.testFairSchedulerPrimaryQueueMapping (batchId=246) org.apache.hive.jdbc.TestSchedulerQueue.testFairSchedulerQueueMapping (batchId=246) org.apache.hive.jdbc.TestSchedulerQueue.testFairSchedulerSecondaryQueueMapping (batchId=246) org.apache.hive.jdbc.TestSchedulerQueue.testQueueMappingCheckDisabled (batchId=246) org.apache.hive.minikdc.TestJdbcWithMiniKdcCookie.testCookieNegative (batchId=254) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/10384/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/10384/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-10384/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 29 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12920002 - PreCommit-HIVE-Build > Assertion error while running materialized view rewriting > --------------------------------------------------------- > > Key: HIVE-19191 > URL: https://issues.apache.org/jira/browse/HIVE-19191 > Project: Hive > Issue Type: Bug > Components: Materialized views > Affects Versions: 3.0.0 > Reporter: Nita Dembla > Assignee: Jesus Camacho Rodriguez > Priority: Major > Attachments: HIVE-19191.01.patch, HIVE-19191.patch > > > {code:sql} > jdbc:hive2://localhost:10007/tpcds_bin_par> explain select > w_warehouse_name,avg(inv_quantity_on_hand) from inventory ,warehouse where > inv_warehouse_sk = w_warehouse_sk group by w_warehouse_name; > Error: Error running query: java.lang.AssertionError: rel > [rel#3663:HiveProject.HIVE.[](input=rel#3662:Subset#8.HIVE.[],$f0=$0,$f1=/($1, > $2))] has lower cost {1.248 rows, 1.248 cpu, 0.0 io} than best cost > {8.963453683875E8 rows, 7.967514387E8 cpu, 0.0 io} of subset > [rel#3664:Subset#9.HIVE.[]] (state=,code=0) > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)