locked
Creating Partition in Azure Sql Data Warehouse database RRS feed

  • Question

  • We created table with partition on datetime and when i tried inserting last one year data the data is being distributed evenly in all the partitions.Data is not moving to dedicated partition. If any one implemented partition in Azure SQL DWH please help..
    CREATE TABLE [dbo].[MADHU] 
    (
    [ID] [nvarchar](40) NULL,
    [TIMESTAMP] [datetime] NOT NULL,
    [CREATED_BY] [nvarchar](20) NOT NULL
    )
    WITH
    (
    DISTRIBUTION = HASH ( [ID] ),CLUSTERED COLUMNSTORE INDEX,
    PARTITION
    (
    [TIMESTAMP] RANGE RIGHT FOR VALUES (N'2015-01-01T00:00:00.000', N'2016-01-01T00:00:00.000', N'2017-01-01T00:00:00.000', N'2018-01-01T00:00:00.000')
    )
    )
    GO

    Partition_nmbr Row_count
    1 56564138
    2 56564138
    3 56564138
    4 56564138
    5 56564138
    6 56564139

    Thursday, February 22, 2018 12:07 PM