[ https://issues.apache.org/jira/browse/HIVE-14431?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16618493#comment-16618493 ]
Hive QA commented on HIVE-14431: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12940038/HIVE-14431.05.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 3 failed/errored test(s), 14969 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[join_cond_pushdown_unqual5] (batchId=71) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_coalesce] (batchId=11) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_coalesce] (batchId=159) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/13874/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/13874/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-13874/ 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: 3 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12940038 - PreCommit-HIVE-Build > Recognize COALESCE as CASE > -------------------------- > > Key: HIVE-14431 > URL: https://issues.apache.org/jira/browse/HIVE-14431 > Project: Hive > Issue Type: Improvement > Components: CBO > Affects Versions: 2.2.0 > Reporter: Jesus Camacho Rodriguez > Assignee: Jesus Camacho Rodriguez > Priority: Major > Attachments: HIVE-14431.01.patch, HIVE-14431.03.patch, > HIVE-14431.04.patch, HIVE-14431.05.patch, HIVE-14431.2.patch, HIVE-14431.patch > > > Transform: > {code} > (COALESCE(a, '') = '') OR > (a = 'A' AND b = c) OR > (a = 'B' AND b = d) OR > (a = 'C' AND b = e) OR > (a = 'D' AND b = f) OR > (a = 'E' AND b = g) OR > (a = 'F' AND b = h) > {code} > into: > {code} > (a='') OR > (a is null) OR > (a = 'A' AND b = c) OR > (a = 'B' AND b = d) OR > (a = 'C' AND b = e) OR > (a = 'D' AND b = f) OR > (a = 'E' AND b = g) OR > (a = 'F' AND b = h) > {code} > With complex queries, this will lead us to factor more predicates that could > be pushed to the TS. -- This message was sent by Atlassian JIRA (v7.6.3#76005)