wenjun ma created HIVE-23866:
--------------------------------
Summary: 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
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)
