question

madhu_3837 avatar image
madhu_3837 asked

Creating Partition in Azure Sql Data Warehouse database

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
azure
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.