[
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)
