Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-23866

Create table fail because duplicated Id with one more HMS on MSSQL

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: All Versions
    • Fix Version/s: None
    • Component/s: Standalone Metastore
    • Labels:
      None

      Description

      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. 

       

        Attachments

          Activity

            People

            • Assignee:
              wenjunma003 wenjun ma
              Reporter:
              wenjunma003 wenjun ma
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: