[ https://issues.apache.org/jira/browse/HIVE-16950?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16263253#comment-16263253 ]
Hive QA commented on HIVE-16950: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12898872/HIVE-16950.2.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 82 failed/errored test(s), 11410 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[alter_change_db_location] (batchId=8) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[dbtxnmgr_showlocks] (batchId=77) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[hybridgrace_hashjoin_2] (batchId=154) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[insert_values_orig_table_use_metadata] (batchId=162) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[llap_acid_fast] (batchId=157) org.apache.hadoop.hive.metastore.TestEmbeddedHiveMetaStore.testDatabaseLocation (batchId=212) org.apache.hadoop.hive.metastore.TestFilterHooks.testDefaultFilter (batchId=211) org.apache.hadoop.hive.metastore.TestFilterHooks.testDummyFilterForPartition (batchId=211) org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStore.testDatabaseLocation (batchId=214) org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testDatabaseLocation (batchId=210) org.apache.hadoop.hive.metastore.TestSetUGIOnOnlyClient.testDatabaseLocation (batchId=209) org.apache.hadoop.hive.metastore.TestSetUGIOnOnlyServer.testDatabaseLocation (batchId=219) org.apache.hadoop.hive.ql.parse.TestCopyUtils.testPrivilegedDistCpWithSameUserAsCurrentDoesNotTryToImpersonate (batchId=224) org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testAlters (batchId=224) org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testBasic (batchId=224) org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testBasicWithCM (batchId=224) org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testBootstrapWithConcurrentDropTable (batchId=224) org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testBootstrapWithConcurrentRename (batchId=224) org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testCMConflict (batchId=224) org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testConcatenatePartitionedTable (batchId=224) org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testConcatenateTable (batchId=224) org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testConstraints (batchId=224) org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testDrops (batchId=224) org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testDropsWithCM (batchId=224) org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testDumpLimit (batchId=224) org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testExchangePartition (batchId=224) org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testIdempotentMoveTaskForInsertFiles (batchId=224) org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testIncrementalAdds (batchId=224) org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testIncrementalInsertDropUnpartitionedTable (batchId=224) org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testIncrementalInserts (batchId=224) org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testIncrementalLoad (batchId=224) org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testIncrementalLoadWithVariableLengthEventId (batchId=224) org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testIncrementalRepeatEventOnExistingObject (batchId=224) org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testIncrementalRepeatEventOnMissingObject (batchId=224) org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testInsertOverwriteOnUnpartitionedTableWithCM (batchId=224) org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testInsertToMultiKeyPartition (batchId=224) org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testRemoveStats (batchId=224) org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testRenamePartitionedTableAcrossDatabases (batchId=224) org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testRenameTableAcrossDatabases (batchId=224) org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testRenameTableWithCM (batchId=224) org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testTruncatePartitionedTable (batchId=224) org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testTruncateTable (batchId=224) org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testTruncateWithCM (batchId=224) org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testViewsReplication (batchId=224) org.apache.hive.hcatalog.api.TestHCatClient.testDatabaseLocation (batchId=185) org.apache.hive.hcatalog.hbase.TestPigHBaseStorageHandler.testPigFilterProjection (batchId=238) org.apache.hive.hcatalog.hbase.TestPigHBaseStorageHandler.testPigPopulation (batchId=238) org.apache.hive.hcatalog.listener.TestDbNotificationListener.cleanupNotifs (batchId=238) org.apache.hive.hcatalog.listener.TestDbNotificationListener.createDatabase (batchId=238) org.apache.hive.hcatalog.listener.TestDbNotificationListener.dropDatabase (batchId=238) org.apache.hive.hcatalog.listener.TestDbNotificationListener.filter (batchId=238) org.apache.hive.hcatalog.listener.TestDbNotificationListener.filterWithMax (batchId=238) org.apache.hive.hcatalog.listener.TestDbNotificationListener.getOnlyMaxEvents (batchId=238) org.apache.hive.hcatalog.streaming.TestStreaming.testAddPartition (batchId=197) org.apache.hive.hcatalog.streaming.TestStreaming.testBucketing (batchId=197) org.apache.hive.hcatalog.streaming.TestStreaming.testBucketingWhereBucketColIsNotFirstCol (batchId=197) org.apache.hive.hcatalog.streaming.TestStreaming.testConcurrentTransactionBatchCommits (batchId=197) org.apache.hive.hcatalog.streaming.TestStreaming.testEndpointConnection (batchId=197) org.apache.hive.hcatalog.streaming.TestStreaming.testErrorHandling (batchId=197) org.apache.hive.hcatalog.streaming.TestStreaming.testFileDump (batchId=197) org.apache.hive.hcatalog.streaming.TestStreaming.testFileDumpCorruptDataFiles (batchId=197) org.apache.hive.hcatalog.streaming.TestStreaming.testFileDumpCorruptSideFiles (batchId=197) org.apache.hive.hcatalog.streaming.TestStreaming.testHeartbeat (batchId=197) org.apache.hive.hcatalog.streaming.TestStreaming.testInterleavedTransactionBatchCommits (batchId=197) org.apache.hive.hcatalog.streaming.TestStreaming.testMultipleTransactionBatchCommits (batchId=197) org.apache.hive.hcatalog.streaming.TestStreaming.testNoBuckets (batchId=197) org.apache.hive.hcatalog.streaming.TestStreaming.testRemainingTransactions (batchId=197) org.apache.hive.hcatalog.streaming.TestStreaming.testStreamBucketingMatchesRegularBucketing (batchId=197) org.apache.hive.hcatalog.streaming.TestStreaming.testTableValidation (batchId=197) org.apache.hive.hcatalog.streaming.TestStreaming.testTimeOutReaper (batchId=197) org.apache.hive.hcatalog.streaming.TestStreaming.testTransactionBatchAbort (batchId=197) org.apache.hive.hcatalog.streaming.TestStreaming.testTransactionBatchAbortAndCommit (batchId=197) org.apache.hive.hcatalog.streaming.TestStreaming.testTransactionBatchCommit_Delimited (batchId=197) org.apache.hive.hcatalog.streaming.TestStreaming.testTransactionBatchCommit_DelimitedUGI (batchId=197) org.apache.hive.hcatalog.streaming.TestStreaming.testTransactionBatchCommit_Json (batchId=197) org.apache.hive.hcatalog.streaming.TestStreaming.testTransactionBatchCommit_Regex (batchId=197) org.apache.hive.hcatalog.streaming.TestStreaming.testTransactionBatchCommit_RegexUGI (batchId=197) org.apache.hive.hcatalog.streaming.TestStreaming.testTransactionBatchEmptyAbort (batchId=197) org.apache.hive.hcatalog.streaming.TestStreaming.testTransactionBatchEmptyCommit (batchId=197) org.apache.hive.jdbc.TestSSL.testConnectionMismatch (batchId=230) org.apache.hive.jdbc.TestSSL.testConnectionWrongCertCN (batchId=230) org.apache.hive.jdbc.TestSSL.testMetastoreConnectionWrongCertCN (batchId=230) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/7972/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/7972/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-7972/ 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: 82 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12898872 - PreCommit-HIVE-Build > Dropping hive database/table which was created explicitly in default database > location, deletes all databases data from default database location > ------------------------------------------------------------------------------------------------------------------------------------------------- > > Key: HIVE-16950 > URL: https://issues.apache.org/jira/browse/HIVE-16950 > Project: Hive > Issue Type: Bug > Components: Hive > Affects Versions: 1.2.1 > Reporter: Rahul Kalgunde > Assignee: Oleksiy Sayankin > Priority: Minor > Attachments: HIVE-16950.1.patch, HIVE-16950.2.patch > > > When database/table is created explicitly pointing to the default location, > dropping the database/table deletes all the data associated with the all > databases/tables. > Steps to replicate: > in below e.g. dropping table test_db2 also deletes data of test_db1 where as > metastore still contains test_db1 > hive> create database test_db1; > OK > Time taken: 4.858 seconds > hive> describe database test_db1; > OK > test_db1 > hdfs://sandbox.hortonworks.com:8020/apps/hive/warehouse/test_db1.db root > USER > Time taken: 0.599 seconds, Fetched: 1 row(s) > hive> create database test_db2 location '/apps/hive/warehouse' ; > OK > Time taken: 1.457 seconds > hive> describe database test_db2; > OK > test_db2 > hdfs://sandbox.hortonworks.com:8020/apps/hive/warehouse root USER > Time taken: 0.582 seconds, Fetched: 1 row(s) > hive> drop database test_db2; > OK > Time taken: 1.317 seconds > hive> dfs -ls /apps/hive/warehouse; > ls: `/apps/hive/warehouse': No such file or directory > Command failed with exit code = 1 > Query returned non-zero code: 1, cause: null > hive> describe database test_db1; > OK > test_db1 > hdfs://sandbox.hortonworks.com:8020/apps/hive/warehouse/test_db1.db root > USER > Time taken: 0.629 seconds, Fetched: 1 row(s) -- This message was sent by Atlassian JIRA (v6.4.14#64029)