You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "wenjun ma (Jira)" <ji...@apache.org> on 2020/07/16 20:44:00 UTC

[jira] [Assigned] (HIVE-23866) Create table fail because duplicated Id with one more HMS on MSSQL

     [ https://issues.apache.org/jira/browse/HIVE-23866?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

wenjun ma reassigned HIVE-23866:
--------------------------------

    Assignee: wenjun ma

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