[
https://issues.apache.org/jira/browse/HIVE-19688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16489742#comment-16489742
]
Alan Gates commented on HIVE-19688:
-----------------------------------
As part of adding this I discovered a critical bug in the --createCatalog
option for schematool. When it adds a catalog it does a select max(CTLD_ID)
from CTLGS and then adds 1. But if the database uses its own sequence to
update this field, this operation interferes with that. The next time a
createCatalog is done via HiveMetaStoreClient it will fail because the value
from the sequence will already be used in the CTLGS table. To fix it I added
2^29 to the value the first time a catalog is added from schematool so that
there is not a clash between the catalogs added by HiveMetaStoreClient and
those added by schematool.
> Make catalogs updatable
> -----------------------
>
> Key: HIVE-19688
> URL: https://issues.apache.org/jira/browse/HIVE-19688
> Project: Hive
> Issue Type: Sub-task
> Components: Metastore
> Affects Versions: 3.0.0
> Reporter: Alan Gates
> Assignee: Alan Gates
> Priority: Major
> Attachments: HIVE-19688.patch
>
>
> The initial changes for catalogs did not include an ability to alter
> catalogs. We need to add that.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
