[ https://issues.apache.org/jira/browse/HIVE-14431?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15423875#comment-15423875 ]
Hive QA commented on HIVE-14431: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12823995/HIVE-14431.2.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 48 failed/errored test(s), 10442 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[alter_merge_orc] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[array_map_access_nonconstant] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[cbo_udf_udaf] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[create_view_translate] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[date_1] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[date_udf] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[deleteAnalyze] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[dynpart_sort_opt_vectorization] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[dynpart_sort_optimization] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[foldts] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[global_limit] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby13] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[input_dynamicserde] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[join_cond_pushdown_unqual5] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[list_bucket_dml_1] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[list_bucket_dml_2] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[list_bucket_dml_3] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[list_bucket_dml_4] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[list_bucket_dml_5] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[list_bucket_dml_6] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[list_bucket_dml_7] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[list_bucket_dml_8] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[list_bucket_dml_9] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[orc_merge10] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[orc_merge1] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[semijoin4] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[semijoin5] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[str_to_map] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[timestamp_udf] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[type_widening] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[udf5] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[udf_folder_constants] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[udf_to_unix_timestamp] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[udf_unix_timestamp] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_coalesce] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_coalesce_2] org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[alter_merge_2_orc] org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[explainuser_1] org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[explainuser_2] org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[load_dyn_part1] org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[transform_ppr1] org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[vector_coalesce] org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[vector_coalesce_2] org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[date_udf] org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[timestamp_udf] org.apache.hive.beeline.TestBeeLineWithArgs.testEmbeddedBeelineOutputs org.apache.hive.jdbc.TestJdbcWithMiniHS2.testSelectThriftSerializeInTasks org.apache.hive.service.cli.operation.TestOperationLoggingLayout.testSwitchLogLayout {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-MASTER-Build/900/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-MASTER-Build/900/console Test logs: http://ec2-204-236-174-241.us-west-1.compute.amazonaws.com/logs/PreCommit-HIVE-MASTER-Build-900/ 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: 48 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12823995 - PreCommit-HIVE-MASTER-Build > Recognize COALESCE as CASE and extend CASE simplification to cover more cases > ----------------------------------------------------------------------------- > > 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 > Attachments: HIVE-14431.01.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 (v6.3.4#6332)