[
https://issues.apache.org/jira/browse/HIVE-19135?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16453155#comment-16453155
]
Thejas M Nair commented on HIVE-19135:
--------------------------------------
[~alangates]
It would be good to have a 'create if not exists' semantics for the create
catalog. That way ambari can just run it in an idempotent fashion.
Also, should we do a "select .. for update" to get a lock on the table, so that
two concurrently running commands don't end up failing because they use same
CTLG_ID.
rs.getInt("CTLG_ID") would be more readable than rs.getInt(1)
getConnectionToMetastore(false) - pass true instead for useful debug info ?
> Need tool to allow admins to create catalogs and move existing dbs to catalog
> during upgrade
> --------------------------------------------------------------------------------------------
>
> Key: HIVE-19135
> URL: https://issues.apache.org/jira/browse/HIVE-19135
> Project: Hive
> Issue Type: Sub-task
> Components: Metastore
> Affects Versions: 3.0.0
> Reporter: Alan Gates
> Assignee: Alan Gates
> Priority: Blocker
> Fix For: 3.1.0
>
> Attachments: HIVE19135.patch
>
>
> As part of upgrading to Hive 3 admins may wish to create new catalogs and
> move some existing databases into those catalogs. We can do this by adding
> options to schematool. This guarantees that only admins can do these
> operations.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
