[ https://issues.apache.org/jira/browse/HIVE-19135?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16453458#comment-16453458 ]
Alan Gates commented on HIVE-19135: ----------------------------------- I've rebased and added a --ifNotExists flag for createCatalog and changed the select to select for update. I don't think I can use rs.getInt("CTLG_ID") since I'm selecting max(CTLG_ID). I pushed my changes to the github branch as well for easier review. > 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: HIVE-19135.2.patch, 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)