[ https://issues.apache.org/jira/browse/HIVE-19433?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16465810#comment-16465810 ]
Hive QA commented on HIVE-19433: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12922201/HIVE-19433.1.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 34 failed/errored test(s), 14322 tests executed *Failed tests:* {noformat} TestDbNotificationListener - did not produce a TEST-*.xml file (likely timed out) (batchId=247) TestHCatHiveCompatibility - did not produce a TEST-*.xml file (likely timed out) (batchId=247) TestNonCatCallsWithCatalog - did not produce a TEST-*.xml file (likely timed out) (batchId=217) TestSequenceFileReadWrite - did not produce a TEST-*.xml file (likely timed out) (batchId=247) TestTxnExIm - did not produce a TEST-*.xml file (likely timed out) (batchId=286) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[bucket_map_join_tez1] (batchId=175) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[bucket_map_join_tez2] (batchId=156) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[mergejoin] (batchId=169) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[sysdb] (batchId=163) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[tez_dynpart_hashjoin_1] (batchId=174) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[tez_vector_dynpart_hashjoin_1] (batchId=172) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[union_fast_stats] (batchId=167) org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[explainanalyze_5] (batchId=105) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[udf_reflect_neg] (batchId=96) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[udf_test_error] (batchId=96) org.apache.hadoop.hive.metastore.client.TestRuntimeStats.testCleanup[Remote] (batchId=209) org.apache.hadoop.hive.ql.TestAcidOnTez.testCtasTezUnion (batchId=228) org.apache.hadoop.hive.ql.TestAcidOnTez.testNonStandardConversion01 (batchId=228) org.apache.hadoop.hive.ql.TestMTQueries.testMTQueries1 (batchId=232) org.apache.hadoop.hive.ql.parse.TestCopyUtils.testPrivilegedDistCpWithSameUserAsCurrentDoesNotTryToImpersonate (batchId=231) org.apache.hadoop.hive.ql.parse.TestReplicationOnHDFSEncryptedZones.targetAndSourceHaveDifferentEncryptionZoneKeys (batchId=231) org.apache.hive.beeline.TestBeeLineWithArgs.testQueryProgressParallel (batchId=235) org.apache.hive.jdbc.TestSSL.testSSLFetchHttp (batchId=239) org.apache.hive.jdbc.TestTriggersWorkloadManager.testMultipleTriggers2 (batchId=241) org.apache.hive.jdbc.TestTriggersWorkloadManager.testTriggerCustomCreatedFiles (batchId=241) org.apache.hive.jdbc.TestTriggersWorkloadManager.testTriggerCustomNonExistent (batchId=241) org.apache.hive.jdbc.TestTriggersWorkloadManager.testTriggerCustomReadOps (batchId=241) org.apache.hive.jdbc.TestTriggersWorkloadManager.testTriggerHighBytesRead (batchId=241) org.apache.hive.jdbc.TestTriggersWorkloadManager.testTriggerHighBytesWrite (batchId=241) org.apache.hive.jdbc.TestTriggersWorkloadManager.testTriggerHighShuffleBytes (batchId=241) org.apache.hive.jdbc.TestTriggersWorkloadManager.testTriggerSlowQueryElapsedTime (batchId=241) org.apache.hive.jdbc.TestTriggersWorkloadManager.testTriggerSlowQueryExecutionTime (batchId=241) org.apache.hive.jdbc.TestTriggersWorkloadManager.testTriggerVertexRawInputSplitsNoKill (batchId=241) org.apache.hive.spark.client.rpc.TestRpc.testServerPort (batchId=304) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/10743/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/10743/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-10743/ 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: 34 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12922201 - PreCommit-HIVE-Build > HiveJoinPushTransitivePredicatesRule hangs > ------------------------------------------ > > Key: HIVE-19433 > URL: https://issues.apache.org/jira/browse/HIVE-19433 > Project: Hive > Issue Type: Bug > Components: Logical Optimizer > Reporter: Vineet Garg > Assignee: Vineet Garg > Priority: Major > Attachments: HIVE-19433.1.patch > > > *Reproducer* > {code:sql} > CREATE TABLE `table1`( > `idp_warehouse_id` bigint, > `idp_audit_id` bigint, > `idp_effective_date` date, > `idp_end_date` date, > `idp_delete_date` date, > `pruid` varchar(32), > `prid` bigint, > `prtimesheetid` bigint, > `prassignmentid` bigint, > `prchargecodeid` bigint, > `prtypecodeid` bigint, > `prsequence` bigint, > `prmodby` varchar(96), > `prmodtime` timestamp, > `prrmexported` bigint, > `prrmckdel` bigint, > `slice_status` int, > `role_id` bigint, > `user_lov1` varchar(30), > `user_lov2` varchar(30), > `incident_id` bigint, > `incident_investment_id` bigint, > `odf_ss_actuals` bigint, > `practsum` decimal(38,20)); > CREATE TABLE `table2`( > `idp_warehouse_id` bigint, > `idp_audit_id` bigint, > `idp_effective_date` date, > `idp_end_date` date, > `idp_delete_date` date, > `pruid` varchar(32), > `prid` bigint, > `prtimesheetid` bigint, > `prassignmentid` bigint, > `prchargecodeid` bigint, > `prtypecodeid` bigint, > `prsequence` bigint, > `prmodby` varchar(96), > `prmodtime` timestamp, > `prrmexported` bigint, > `prrmckdel` bigint, > `slice_status` int, > `role_id` bigint, > `user_lov1` varchar(30), > `user_lov2` varchar(30), > `incident_id` bigint, > `incident_investment_id` bigint, > `odf_ss_actuals` bigint, > `practsum` decimal(38,20)); > explain SELECT s.idp_warehouse_id AS source_warehouse_id > FROM table1 s > JOIN > table2 d > ON ( > s.prid = d.prid ) > JOIN > table2 e > ON > s.prid = e.prid > WHERE > concat( > CASE > WHEN s.prid IS NULL THEN 1 > ELSE s.prid > END,',', > CASE > WHEN s.prtimesheetid IS NULL THEN 1 > ELSE s.prtimesheetid > END,',', > CASE > WHEN s.prassignmentid IS NULL THEN 1 > ELSE s.prassignmentid > END,',', > CASE > WHEN s.prchargecodeid IS NULL THEN 1 > ELSE s.prchargecodeid > END,',', > CASE > WHEN (s.prtypecodeid) IS NULL THEN '' > ELSE s.prtypecodeid > END,',', > CASE > WHEN s.practsum IS NULL THEN 1 > ELSE s.practsum > END,',', > CASE > WHEN s.prsequence IS NULL THEN 1 > ELSE s.prsequence > END,',', > CASE > WHEN length(s.prmodby) IS NULL THEN '' > ELSE s.prmodby > END,',', > CASE > WHEN s.prmodtime IS NULL THEN > cast(from_unixtime(unix_timestamp('2017-12-08','yyyy-MM-dd') ) AS timestamp) > ELSE s.prmodtime > END,',', > CASE > WHEN s.prrmexported IS NULL THEN 1 > ELSE s.prrmexported > END,',', > CASE > WHEN s.prrmckdel IS NULL THEN 1 > ELSE s.prrmckdel > END,',', > CASE > WHEN s.slice_status IS NULL THEN 1 > ELSE s.slice_status > END,',', > CASE > WHEN s.role_id IS NULL THEN 1 > ELSE s.role_id > END,',', > CASE > WHEN length(s.user_lov1) IS NULL THEN '' > ELSE s.user_lov1 > END,',', > CASE > WHEN length(s.user_lov2) IS NULL THEN '' > ELSE s.user_lov2 > END,',', > CASE > WHEN s.incident_id IS NULL THEN 1 > ELSE s.incident_id > END,',', > CASE > WHEN s.incident_investment_id IS NULL > THEN 1 > ELSE s.incident_investment_id > END,',', > CASE > WHEN s.odf_ss_actuals IS NULL THEN 1 > ELSE s.odf_ss_actuals > END ) != concat( > CASE > WHEN length(d.pruid) IS NULL THEN '' > ELSE d.pruid > END,',', > CASE > WHEN d.prid IS NULL THEN 1 > ELSE d.prid > END,',', > CASE > WHEN d.prtimesheetid IS NULL THEN 1 > ELSE d.prtimesheetid > END,',', > CASE > WHEN d.prassignmentid IS NULL THEN 1 > ELSE d.prassignmentid > END,',', > CASE > WHEN d.prchargecodeid IS NULL THEN 1 > ELSE d.prchargecodeid > END,',', > CASE > WHEN (d.prtypecodeid) IS NULL THEN '' > ELSE d.prtypecodeid > END,',', > CASE > WHEN d.practsum IS NULL THEN 1 > ELSE d.practsum > END,',', > CASE > WHEN d.prsequence IS NULL THEN 1 > ELSE d.prsequence > END,',', > CASE > WHEN length(d.prmodby) IS NULL THEN '' > ELSE d.prmodby > END,',', > CASE > WHEN d.prmodtime IS NULL THEN > cast(from_unixtime(unix_timestamp('2017-12-08','yyyy-MM-dd') ) AS timestamp) > ELSE d.prmodtime > END,',', > CASE > WHEN d.prrmexported IS NULL THEN 1 > ELSE d.prrmexported > END,',', > CASE > WHEN d.prrmckdel IS NULL THEN 1 > ELSE d.prrmckdel > END,',', > CASE > WHEN d.slice_status IS NULL THEN 1 > ELSE d.slice_status > END,',', > CASE > WHEN d.role_id IS NULL THEN 1 > ELSE d.role_id > END,',', > CASE > WHEN length(d.user_lov1) IS NULL THEN '' > ELSE d.user_lov1 > END,',', > CASE > WHEN length(d.user_lov2) IS NULL THEN '' > ELSE d.user_lov2 > END,',', > CASE > WHEN d.incident_id IS NULL THEN 1 > ELSE d.incident_id > END,',', > CASE > WHEN d.incident_investment_id IS NULL > THEN 1 > ELSE d.incident_investment_id > END,',', > CASE > WHEN d.odf_ss_actuals IS NULL THEN 1 > ELSE d.odf_ss_actuals > END ); > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)