You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Alan Gates (JIRA)" <ji...@apache.org> on 2018/05/24 20:30:00 UTC

[jira] [Commented] (HIVE-19688) Make catalogs updatable

    [ 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)