[ https://issues.apache.org/jira/browse/HIVE-22785?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17066711#comment-17066711 ]
Hive QA commented on HIVE-22785: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12997665/HIVE-22785.11.patch {color:green}SUCCESS:{color} +1 due to 3 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 76 failed/errored test(s), 18127 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[update_notnull_constraint] (batchId=106) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.deprecatedCalls[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.otherCatalog[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionBogusCatalogName[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionChangeDbName[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionChangeTableName[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionChangeValues[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionIncompletePartitionVals[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionMissingPartitionVals[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionNoDbName[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionNoTblName[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionNullDbName[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionNullPartition[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionNullTblName[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionUnknownPartition[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionWithEnvironmentCtxChangeDbName[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionWithEnvironmentCtxChangeTableName[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionWithEnvironmentCtxChangeValues[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionWithEnvironmentCtxIncompletePartitionVals[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionWithEnvironmentCtxMissingPartitionVals[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionWithEnvironmentCtxNoDbName[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionWithEnvironmentCtxNoTblName[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionWithEnvironmentCtxNullDbName[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionWithEnvironmentCtxNullPartition[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionWithEnvironmentCtxNullTblName[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionWithEnvironmentCtxUnknownPartition[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionWithEnvironmentCtx[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartition[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsBogusCatalogName[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsChangeDbName[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsChangeTableName[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsChangeValues[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsEmptyPartitionList[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsIncompletePartitionVals[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsMissingPartitionVals[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsNoDbName[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsNoTblName[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsNullDbName[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsNullPartitionList[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsNullPartition[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsNullPartitions[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsNullTblName[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsUnknownPartition[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsWithEnvironmentCtxBogusCatalogName[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsWithEnvironmentCtxChangeDbName[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsWithEnvironmentCtxChangeTableName[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsWithEnvironmentCtxChangeValues[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsWithEnvironmentCtxEmptyPartitionList[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsWithEnvironmentCtxIncompletePartitionVals[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsWithEnvironmentCtxMissingPartitionVals[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsWithEnvironmentCtxNoDbName[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsWithEnvironmentCtxNoTblName[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsWithEnvironmentCtxNullDbName[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsWithEnvironmentCtxNullPartitionList[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsWithEnvironmentCtxNullPartition[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsWithEnvironmentCtxNullPartitions[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsWithEnvironmentCtxNullTblName[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsWithEnvironmentCtxUnknownPartition[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsWithEnvironmentCtx[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitions[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testRenamePartitionBogusCatalogName[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testRenamePartitionChangeDbName[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testRenamePartitionChangeTblName[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testRenamePartitionEmptyOldPartList[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testRenamePartitionNoDbName[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testRenamePartitionNoSuchOldPartition[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testRenamePartitionNoTable[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testRenamePartitionNoTblName[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testRenamePartitionNullDbInPartition[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testRenamePartitionNullDbName[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testRenamePartitionNullNewPart[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testRenamePartitionNullOldPartList[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testRenamePartitionNullTableInPartition[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testRenamePartitionNullTblName[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testRenamePartitionTargetAlreadyExisting[Remote] (batchId=232) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testRenamePartition[Remote] (batchId=232) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/21263/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/21263/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-21263/ 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: 76 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12997665 - PreCommit-HIVE-Build > Update/delete/merge statements not optimized through CBO > -------------------------------------------------------- > > Key: HIVE-22785 > URL: https://issues.apache.org/jira/browse/HIVE-22785 > Project: Hive > Issue Type: Improvement > Components: CBO > Reporter: Jesus Camacho Rodriguez > Assignee: Krisztian Kasa > Priority: Critical > Attachments: HIVE-22785.1.patch, HIVE-22785.10.patch, > HIVE-22785.11.patch, HIVE-22785.2.patch, HIVE-22785.2.patch, > HIVE-22785.3.patch, HIVE-22785.4.patch, HIVE-22785.5.patch, > HIVE-22785.6.patch, HIVE-22785.7.patch, HIVE-22785.8.patch, HIVE-22785.9.patch > > > Currently, CBO is bypassed for update/delete/merge statements. > To support optimizing these statements through CBO, we need to complete three > main tasks: 1) support for sort in Calcite planner, 2) support for SORT in > AST converter, and 3) {{RewriteSemanticAnalyzer}} should extend > {{CalcitePlanner}} instead of {{SemanticAnalyzer}}. -- This message was sent by Atlassian Jira (v8.3.4#803005)