[
https://issues.apache.org/jira/browse/HIVE-23866?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17412752#comment-17412752
]
Cedric Baril-Leroux commented on HIVE-23866:
--------------------------------------------
[~wenjunma003] Any updates on your pull request?
> Create table fail because duplicated Id with one more HMS on MSSQL
> ------------------------------------------------------------------
>
> Key: HIVE-23866
> URL: https://issues.apache.org/jira/browse/HIVE-23866
> Project: Hive
> Issue Type: Bug
> Components: Standalone Metastore
> Affects Versions: All Versions
> Reporter: wenjun ma
> Assignee: wenjun ma
> Priority: Major
>
> Condition:
> 1. Heavy DDL submitted to HS2.
> 2. Muti HMS
> 3. MS SQL as backend DB for HMS.
> When customer create the table they will get following error:
> org.apache.hadoop.hive.metastore.model.MTableColumnPrivilege@ce80aa0" using
> statement "INSERT INTO TBL_COL_PRIVS
> (TBL_COLUMN_GRANT_ID,AUTHORIZER,"COLUMN_NAME",CREATE_TIME,GRANT_OPTION,GRANTOR,GRANTOR_TYPE,PRINCIPAL_NAME,PRINCIPAL_TYPE,TBL_COL_PRIV,TBL_ID)
> VALUES (?,?,?,?,?,?,?,?,?,?,?)" failed : Violation of PRIMARY KEY constraint
> 'PK_tbl_col_privs_TBL_COLUMN_GRANT_ID'. Cannot insert duplicate key in object
> 'dbo.TBL_COL_PRIVS'. The duplicate key value is (241408091).
>
> After debugging I found It's the issue from DataNucleus I will submitted PR
> to DataNucleus to fix this issue.
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
