[
https://issues.apache.org/jira/browse/HIVE-23207?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17084296#comment-17084296
]
Hive QA commented on HIVE-23207:
--------------------------------
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/13000016/HIVE-23207.3.patch
{color:green}SUCCESS:{color} +1 due to 4 test(s) being added or modified.
{color:red}ERROR:{color} -1 due to 95 failed/errored test(s), 16829 tests
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestAccumuloCliDriver.org.apache.hadoop.hive.cli.TestAccumuloCliDriver
(batchId=220)
org.apache.hadoop.hive.cli.TestBeeLineDriver.org.apache.hadoop.hive.cli.TestBeeLineDriver
(batchId=228)
org.apache.hadoop.hive.cli.TestBlobstoreCliDriver.org.apache.hadoop.hive.cli.TestBlobstoreCliDriver
(batchId=230)
org.apache.hadoop.hive.cli.TestBlobstoreNegativeCliDriver.org.apache.hadoop.hive.cli.TestBlobstoreNegativeCliDriver
(batchId=230)
org.apache.hadoop.hive.cli.TestContribCliDriver.testCliDriver[url_hook]
(batchId=223)
org.apache.hadoop.hive.cli.TestKuduCliDriver.org.apache.hadoop.hive.cli.TestKuduCliDriver
(batchId=219)
org.apache.hadoop.hive.cli.TestKuduNegativeCliDriver.org.apache.hadoop.hive.cli.TestKuduNegativeCliDriver
(batchId=219)
org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query68]
(batchId=228)
org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[mv_query44]
(batchId=228)
org.apache.hadoop.hive.metastore.TestAcidTableSetup.testTransactionalValidation
(batchId=171)
org.apache.hadoop.hive.metastore.TestFilterHooks.testHMSClientWithFilter
(batchId=151)
org.apache.hadoop.hive.metastore.TestFilterHooks.testHMSClientWithoutFilter
(batchId=151)
org.apache.hadoop.hive.metastore.TestFilterHooks.testHMSServerWithFilter
(batchId=151)
org.apache.hadoop.hive.metastore.TestFilterHooks.testHMSServerWithoutFilter
(batchId=151)
org.apache.hadoop.hive.metastore.TestMetastoreHousekeepingLeader.testHouseKeepingThreadExistence
(batchId=171)
org.apache.hadoop.hive.metastore.TestMetastoreHousekeepingLeaderEmptyConfig.testHouseKeepingThreadExistence
(batchId=173)
org.apache.hadoop.hive.metastore.TestPartitionManagement.testNoPartitionDiscoveryForReplTable
(batchId=151)
org.apache.hadoop.hive.metastore.TestPartitionManagement.testNoPartitionRetentionForReplTarget
(batchId=151)
org.apache.hadoop.hive.metastore.TestPartitionManagement.testPartitionDiscoveryDBPattern
(batchId=151)
org.apache.hadoop.hive.metastore.TestPartitionManagement.testPartitionDiscoveryDisabledByDefault
(batchId=151)
org.apache.hadoop.hive.metastore.TestPartitionManagement.testPartitionDiscoveryEnabledBothTableTypes
(batchId=151)
org.apache.hadoop.hive.metastore.TestPartitionManagement.testPartitionDiscoveryNonDefaultCatalog
(batchId=151)
org.apache.hadoop.hive.metastore.TestPartitionManagement.testPartitionDiscoverySkipInvalidPath
(batchId=151)
org.apache.hadoop.hive.metastore.TestPartitionManagement.testPartitionDiscoveryTablePattern
(batchId=151)
org.apache.hadoop.hive.metastore.TestPartitionManagement.testPartitionDiscoveryTransactionalTable
(batchId=151)
org.apache.hadoop.hive.metastore.TestPartitionManagement.testPartitionExprFilter
(batchId=151)
org.apache.hadoop.hive.metastore.TestPartitionManagement.testPartitionRetention
(batchId=151)
org.apache.hadoop.hive.metastore.cache.TestCachedStoreUpdateUsingEvents.testAggrStat
(batchId=173)
org.apache.hadoop.hive.metastore.cache.TestCachedStoreUpdateUsingEvents.testAggrStatAbortTxn
(batchId=173)
org.apache.hadoop.hive.metastore.cache.TestCachedStoreUpdateUsingEvents.testAggrStatTxnTable
(batchId=173)
org.apache.hadoop.hive.metastore.cache.TestCachedStoreUpdateUsingEvents.testTableColumnStatisticsTxnTable
(batchId=173)
org.apache.hadoop.hive.metastore.cache.TestCachedStoreUpdateUsingEvents.testTableColumnStatisticsTxnTableMulti
(batchId=173)
org.apache.hadoop.hive.metastore.cache.TestCachedStoreUpdateUsingEvents.testTableColumnStatisticsTxnTableMultiAbort
(batchId=173)
org.apache.hadoop.hive.metastore.cache.TestCachedStoreUpdateUsingEvents.testTableColumnStatisticsTxnTableOpenTxn
(batchId=173)
org.apache.hadoop.hive.ql.parse.TestCopyUtils.org.apache.hadoop.hive.ql.parse.TestCopyUtils
(batchId=204)
org.apache.hadoop.hive.ql.parse.TestExportImport.org.apache.hadoop.hive.ql.parse.TestExportImport
(batchId=179)
org.apache.hadoop.hive.ql.parse.TestMetaStoreEventListenerInRepl.org.apache.hadoop.hive.ql.parse.TestMetaStoreEventListenerInRepl
(batchId=179)
org.apache.hadoop.hive.ql.parse.TestReplAcidTablesBootstrapWithJsonMessage.org.apache.hadoop.hive.ql.parse.TestReplAcidTablesBootstrapWithJsonMessage
(batchId=181)
org.apache.hadoop.hive.ql.parse.TestReplAcidTablesWithJsonMessage.org.apache.hadoop.hive.ql.parse.TestReplAcidTablesWithJsonMessage
(batchId=198)
org.apache.hadoop.hive.ql.parse.TestReplAcrossInstancesWithJsonMessageFormat.org.apache.hadoop.hive.ql.parse.TestReplAcrossInstancesWithJsonMessageFormat
(batchId=190)
org.apache.hadoop.hive.ql.parse.TestReplScenariosWithStrictManaged.org.apache.hadoop.hive.ql.parse.TestReplScenariosWithStrictManaged
(batchId=192)
org.apache.hadoop.hive.ql.parse.TestReplTableMigrationWithJsonFormat.org.apache.hadoop.hive.ql.parse.TestReplTableMigrationWithJsonFormat
(batchId=196)
org.apache.hadoop.hive.ql.parse.TestReplicationOfHiveStreaming.org.apache.hadoop.hive.ql.parse.TestReplicationOfHiveStreaming
(batchId=177)
org.apache.hadoop.hive.ql.parse.TestReplicationOnHDFSEncryptedZones.org.apache.hadoop.hive.ql.parse.TestReplicationOnHDFSEncryptedZones
(batchId=204)
org.apache.hadoop.hive.ql.parse.TestReplicationScenariosAcidTables.org.apache.hadoop.hive.ql.parse.TestReplicationScenariosAcidTables
(batchId=200)
org.apache.hadoop.hive.ql.parse.TestReplicationScenariosAcidTablesBootstrap.org.apache.hadoop.hive.ql.parse.TestReplicationScenariosAcidTablesBootstrap
(batchId=178)
org.apache.hadoop.hive.ql.parse.TestReplicationScenariosAcrossInstances.org.apache.hadoop.hive.ql.parse.TestReplicationScenariosAcrossInstances
(batchId=194)
org.apache.hadoop.hive.ql.parse.TestReplicationScenariosExternalTables.org.apache.hadoop.hive.ql.parse.TestReplicationScenariosExternalTables
(batchId=189)
org.apache.hadoop.hive.ql.parse.TestReplicationScenariosExternalTablesMetaDataOnly.org.apache.hadoop.hive.ql.parse.TestReplicationScenariosExternalTablesMetaDataOnly
(batchId=204)
org.apache.hadoop.hive.ql.parse.TestReplicationScenariosIncrementalLoadAcidTables.org.apache.hadoop.hive.ql.parse.TestReplicationScenariosIncrementalLoadAcidTables
(batchId=201)
org.apache.hadoop.hive.ql.parse.TestReplicationWithTableMigration.org.apache.hadoop.hive.ql.parse.TestReplicationWithTableMigration
(batchId=185)
org.apache.hadoop.hive.ql.parse.TestReplicationWithTableMigrationEx.org.apache.hadoop.hive.ql.parse.TestReplicationWithTableMigrationEx
(batchId=195)
org.apache.hadoop.hive.ql.parse.TestScheduledReplicationScenarios.org.apache.hadoop.hive.ql.parse.TestScheduledReplicationScenarios
(batchId=204)
org.apache.hadoop.hive.ql.parse.TestStatsReplicationScenarios.org.apache.hadoop.hive.ql.parse.TestStatsReplicationScenarios
(batchId=202)
org.apache.hadoop.hive.ql.parse.TestStatsReplicationScenariosACID.org.apache.hadoop.hive.ql.parse.TestStatsReplicationScenariosACID
(batchId=183)
org.apache.hadoop.hive.ql.parse.TestStatsReplicationScenariosMM.org.apache.hadoop.hive.ql.parse.TestStatsReplicationScenariosMM
(batchId=188)
org.apache.hadoop.hive.ql.parse.TestStatsReplicationScenariosMMNoAutogather.org.apache.hadoop.hive.ql.parse.TestStatsReplicationScenariosMMNoAutogather
(batchId=180)
org.apache.hadoop.hive.ql.parse.TestStatsReplicationScenariosMigration.org.apache.hadoop.hive.ql.parse.TestStatsReplicationScenariosMigration
(batchId=187)
org.apache.hadoop.hive.ql.parse.TestStatsReplicationScenariosMigrationNoAutogather.org.apache.hadoop.hive.ql.parse.TestStatsReplicationScenariosMigrationNoAutogather
(batchId=197)
org.apache.hadoop.hive.ql.parse.TestStatsReplicationScenariosNoAutogather.org.apache.hadoop.hive.ql.parse.TestStatsReplicationScenariosNoAutogather
(batchId=199)
org.apache.hadoop.hive.ql.parse.TestTableLevelReplicationScenarios.org.apache.hadoop.hive.ql.parse.TestTableLevelReplicationScenarios
(batchId=186)
org.apache.hadoop.hive.ql.parse.TestUpdateDeleteSemanticAnalyzer.testDeleteAllNonPartitioned
(batchId=257)
org.apache.hadoop.hive.ql.parse.TestUpdateDeleteSemanticAnalyzer.testDeleteAllPartitioned
(batchId=257)
org.apache.hadoop.hive.ql.parse.TestUpdateDeleteSemanticAnalyzer.testDeleteAllWherePartitioned
(batchId=257)
org.apache.hadoop.hive.ql.parse.TestUpdateDeleteSemanticAnalyzer.testDeleteOnePartition
(batchId=257)
org.apache.hadoop.hive.ql.parse.TestUpdateDeleteSemanticAnalyzer.testDeleteOnePartitionWhere
(batchId=257)
org.apache.hadoop.hive.ql.parse.TestUpdateDeleteSemanticAnalyzer.testDeleteWhereNoPartition
(batchId=257)
org.apache.hadoop.hive.ql.parse.TestUpdateDeleteSemanticAnalyzer.testInsertSelect
(batchId=257)
org.apache.hadoop.hive.ql.parse.TestUpdateDeleteSemanticAnalyzer.testInsertValues
(batchId=257)
org.apache.hadoop.hive.ql.parse.TestUpdateDeleteSemanticAnalyzer.testInsertValuesPartitioned
(batchId=257)
org.apache.hadoop.hive.ql.parse.TestUpdateDeleteSemanticAnalyzer.testUpdateAllNonPartitioned
(batchId=257)
org.apache.hadoop.hive.ql.parse.TestUpdateDeleteSemanticAnalyzer.testUpdateAllNonPartitionedWhere
(batchId=257)
org.apache.hadoop.hive.ql.parse.TestUpdateDeleteSemanticAnalyzer.testUpdateAllPartitioned
(batchId=257)
org.apache.hadoop.hive.ql.parse.TestUpdateDeleteSemanticAnalyzer.testUpdateAllPartitionedWhere
(batchId=257)
org.apache.hadoop.hive.ql.parse.TestUpdateDeleteSemanticAnalyzer.testUpdateOnePartition
(batchId=257)
org.apache.hadoop.hive.ql.parse.TestUpdateDeleteSemanticAnalyzer.testUpdateOnePartitionWhere
(batchId=257)
org.apache.hadoop.hive.ql.security.authorization.plugin.TestHiveAuthorizerCheckInvocation.org.apache.hadoop.hive.ql.security.authorization.plugin.TestHiveAuthorizerCheckInvocation
(batchId=207)
org.apache.hadoop.hive.ql.security.authorization.plugin.TestHivePrivilegeObjectOwnerNameAndType.org.apache.hadoop.hive.ql.security.authorization.plugin.TestHivePrivilegeObjectOwnerNameAndType
(batchId=280)
org.apache.hive.hcatalog.listener.TestDbNotificationListener.abortTxn
(batchId=222)
org.apache.hive.hcatalog.listener.TestDbNotificationListener.commitTxn
(batchId=222)
org.apache.hive.hcatalog.listener.TestDbNotificationListener.openTxn
(batchId=222)
org.apache.hive.hcatalog.listener.TestDbNotificationListener.rollbackTxn
(batchId=222)
org.apache.hive.jdbc.TestJdbcDriver2.testCloseResultSet (batchId=214)
org.apache.hive.jdbc.TestJdbcDriver2.testCreateTableExecAsync (batchId=214)
org.apache.hive.jdbc.TestJdbcDriver2.testExceucteUpdateCounts (batchId=214)
org.apache.hive.jdbc.TestJdbcDriver2.testNullResultSet (batchId=214)
org.apache.hive.jdbc.TestJdbcDriver2.testPrepareSetDate (batchId=214)
org.apache.hive.jdbc.TestJdbcDriver2.testPrepareStatement (batchId=214)
org.apache.hive.jdbc.TestJdbcDriver2.testQueryCancel (batchId=214)
org.apache.hive.jdbc.TestJdbcDriver2.testQueryCancelTwice (batchId=214)
org.apache.hive.jdbc.TestJdbcDriver2.testReplErrorScenarios (batchId=214)
org.apache.hive.jdbc.TestJdbcDriver2.testResultNextAcidTable (batchId=214)
org.apache.hive.jdbc.TestJdbcDriver2.testSelectAllMaxRows (batchId=214)
org.apache.hive.jdbc.TestJdbcDriver2.testShowRoleGrant (batchId=214)
org.apache.hive.jdbc.TestJdbcDriver2.testYarnATSGuid (batchId=214)
{noformat}
Test results:
https://builds.apache.org/job/PreCommit-HIVE-Build/21679/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/21679/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-21679/
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: 95 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 13000016 - PreCommit-HIVE-Build
> Create integration tests for TxnManager for different rdbms metastores
> ----------------------------------------------------------------------
>
> Key: HIVE-23207
> URL: https://issues.apache.org/jira/browse/HIVE-23207
> Project: Hive
> Issue Type: Improvement
> Reporter: Peter Varga
> Assignee: Peter Varga
> Priority: Minor
> Attachments: HIVE-23207.1.patch, HIVE-23207.2.patch,
> HIVE-23207.3.patch
>
>
> Create an integration test suite that runs tests for TxnManager with the
> metastore configured to use different kind of RDBMS-s. Use the differentÂ
> DatabaseRule-s defined in the standalone-metastore for docker environments,
> and use the real init schema for every database type instead of the hardwired
> TxnDbUtil.prepDb.
> This test will be useful for easy manual validation of schema changes.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
