locked
identidy column RRS feed

  • Question

  • I have the following table

    CREATE TABLE dbo.T1
    ( C1 INT IDENTITY(1000,1) NOT NULL
    , C2 INT NULL
    )
    WITH
    (   DISTRIBUTION = replicate
    ,   heap
    )

    And then insert

    insert into dbo.T1 (c2) values(2)

    But the results in not incrementing in the identity column

    Wednesday, June 12, 2019 4:38 AM

All replies

  • Hi Sakurai,

    Due to the way the data warehouse works (with 60 distributions) you will have gaps in the identity columns due to data skew.

    For a longer explanation see: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-tables-identity

    Wednesday, June 12, 2019 7:20 AM
  • Hello Sakurai,

    As Daniel has suggested above, this behavior is by design.

    Wednesday, June 12, 2019 9:21 AM
  • thanks for sharing
    Wednesday, June 12, 2019 5:05 PM