hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hive QA (Jira)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-22995) Add support for location for managed tables on database
Date Tue, 24 Mar 2020 07:55:00 GMT

    [ https://issues.apache.org/jira/browse/HIVE-22995?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17065402#comment-17065402
] 

Hive QA commented on HIVE-22995:
--------------------------------



Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12997508/HIVE-22995.9.patch

{color:green}SUCCESS:{color} +1 due to 7 test(s) being added or modified.

{color:red}ERROR:{color} -1 due to 58 failed/errored test(s), 18130 tests executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[ctas_uses_database_location] (batchId=40)
org.apache.hadoop.hive.cli.TestEncryptedHDFSCliDriver.testCliDriver[encryption_move_tbl] (batchId=196)
org.apache.hadoop.hive.metastore.TestCatalogNonDefaultClient.tablesCreateDropAlterTruncate
(batchId=230)
org.apache.hadoop.hive.metastore.TestCatalogNonDefaultSvr.tablesCreateDropAlterTruncate (batchId=239)
org.apache.hadoop.hive.metastore.TestCatalogOldClient.databases (batchId=230)
org.apache.hadoop.hive.metastore.TestEmbeddedHiveMetaStore.testAlterTable (batchId=233)
org.apache.hadoop.hive.metastore.TestEmbeddedHiveMetaStore.testTableDatabase (batchId=233)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStore.testAlterTable (batchId=235)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStore.testTableDatabase (batchId=235)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreCustomAuth.testAlterTable (batchId=239)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreCustomAuth.testTableDatabase (batchId=239)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testAlterTable (batchId=234)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testTableDatabase (batchId=234)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZKBindHost.testAlterTable (batchId=241)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZKBindHost.testTableDatabase (batchId=241)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testAlterTable (batchId=231)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testTableDatabase (batchId=231)
org.apache.hadoop.hive.metastore.TestSetUGIOnOnlyClient.testAlterTable (batchId=229)
org.apache.hadoop.hive.metastore.TestSetUGIOnOnlyClient.testTableDatabase (batchId=229)
org.apache.hadoop.hive.metastore.TestSetUGIOnOnlyServer.testAlterTable (batchId=240)
org.apache.hadoop.hive.metastore.TestSetUGIOnOnlyServer.testTableDatabase (batchId=240)
org.apache.hadoop.hive.metastore.client.TestTablesCreateDropAlterTruncate.tablesInOtherCatalogs[Embedded]
(batchId=230)
org.apache.hadoop.hive.metastore.client.TestTablesCreateDropAlterTruncate.tablesInOtherCatalogs[Remote]
(batchId=230)
org.apache.hadoop.hive.metastore.client.TestTablesCreateDropAlterTruncate.testCreateTableDefaultLocationInSpecificDatabase[Embedded]
(batchId=230)
org.apache.hadoop.hive.metastore.client.TestTablesCreateDropAlterTruncate.testCreateTableDefaultLocationInSpecificDatabase[Remote]
(batchId=230)
org.apache.hadoop.hive.ql.TestDDLWithRemoteMetastoreSecondNamenode.testCreateDatabaseWithTableNonDefaultNameNode
(batchId=264)
org.apache.hadoop.hive.ql.TestWarehouseExternalDir.testManagedPaths (batchId=264)
org.apache.hadoop.hive.ql.parse.TestReplWithJsonMessageFormat.testBootstrapWithDataInDumpDir
(batchId=260)
org.apache.hadoop.hive.ql.parse.TestReplWithJsonMessageFormat.testDropsWithCM (batchId=260)
org.apache.hadoop.hive.ql.parse.TestReplWithJsonMessageFormat.testDumpWithPartitionDirMissing
(batchId=260)
org.apache.hadoop.hive.ql.parse.TestReplWithJsonMessageFormat.testDumpWithTableDirMissing
(batchId=260)
org.apache.hadoop.hive.ql.parse.TestReplWithJsonMessageFormat.testIncrementalAdds (batchId=260)
org.apache.hadoop.hive.ql.parse.TestReplWithJsonMessageFormat.testIncrementalInsertDropPartitionedTable
(batchId=260)
org.apache.hadoop.hive.ql.parse.TestReplWithJsonMessageFormat.testIncrementalInsertDropUnpartitionedTable
(batchId=260)
org.apache.hadoop.hive.ql.parse.TestReplWithJsonMessageFormat.testIncrementalLoadFailAndRetry
(batchId=260)
org.apache.hadoop.hive.ql.parse.TestReplWithJsonMessageFormat.testIncrementalRepeatEventOnExistingObject
(batchId=260)
org.apache.hadoop.hive.ql.parse.TestReplWithJsonMessageFormat.testMoveOptimizationIncremental
(batchId=260)
org.apache.hadoop.hive.ql.parse.TestReplWithJsonMessageFormat.testRenamePartitionedTableAcrossDatabases
(batchId=260)
org.apache.hadoop.hive.ql.parse.TestReplWithJsonMessageFormat.testRenameTableAcrossDatabases
(batchId=260)
org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testBootstrapWithDataInDumpDir (batchId=270)
org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testDropsWithCM (batchId=270)
org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testDumpWithPartitionDirMissing (batchId=270)
org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testDumpWithTableDirMissing (batchId=270)
org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testIncrementalAdds (batchId=270)
org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testIncrementalInsertDropPartitionedTable
(batchId=270)
org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testIncrementalInsertDropUnpartitionedTable
(batchId=270)
org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testIncrementalLoadFailAndRetry (batchId=270)
org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testIncrementalRepeatEventOnExistingObject
(batchId=270)
org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testMoveOptimizationIncremental (batchId=270)
org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testRenamePartitionedTableAcrossDatabases
(batchId=270)
org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testRenameTableAcrossDatabases (batchId=270)
org.apache.hadoop.hive.ql.parse.TestReplicationScenariosExternalTables.bootstrapExternalTablesDuringIncrementalPhase
(batchId=268)
org.apache.hadoop.hive.ql.parse.TestReplicationScenariosExternalTables.retryBootstrapExternalTablesFromDifferentDump
(batchId=268)
org.apache.hadoop.hive.ql.parse.TestReplicationScenariosExternalTablesMetaDataOnly.bootstrapExternalTablesDuringIncrementalPhase
(batchId=264)
org.apache.hadoop.hive.ql.security.TestStorageBasedMetastoreAuthorizationProviderWithACL.testSimplePrivileges
(batchId=299)
org.apache.hive.minikdc.TestRemoteHiveMetaStoreDualAuthCustom.testTableDatabase (batchId=307)
org.apache.hive.minikdc.TestRemoteHiveMetaStoreDualAuthKerb.testTableDatabase (batchId=307)
org.apache.hive.minikdc.TestRemoteHiveMetaStoreKerberos.testTableDatabase (batchId=307)
{noformat}

Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/21245/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/21245/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-21245/

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: 58 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12997508 - PreCommit-HIVE-Build

> Add support for location for managed tables on database
> -------------------------------------------------------
>
>                 Key: HIVE-22995
>                 URL: https://issues.apache.org/jira/browse/HIVE-22995
>             Project: Hive
>          Issue Type: Improvement
>          Components: Hive
>    Affects Versions: 3.1.0
>            Reporter: Naveen Gangam
>            Assignee: Naveen Gangam
>            Priority: Major
>         Attachments: HIVE-22995.1.patch, HIVE-22995.2.patch, HIVE-22995.3.patch, HIVE-22995.4.patch,
HIVE-22995.5.patch, HIVE-22995.6.patch, HIVE-22995.7.patch, HIVE-22995.8.patch, HIVE-22995.9.patch,
Hive Metastore Support for Tenant-based storage heirarchy.pdf
>
>
> I have attached the initial spec to this jira.
> Default location for database would be the external table base directory. Managed location
can be optionally specified.
> {code}
> CREATE (DATABASE|SCHEMA) [IF NOT EXISTS] database_name
>   [COMMENT database_comment]
>   [LOCATION hdfs_path]
> [MANAGEDLOCATION hdfs_path]
>   [WITH DBPROPERTIES (property_name=property_value, ...)];
> ALTER (DATABASE|SCHEMA) database_name SET 
> MANAGEDLOCATION
>  hdfs_path;
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Mime
View raw message