将ADX表在策略保留期间指定为UTC时间。代码示例如下:
CREATE TABLE myTable (
field1 string,
field2 int,
field3 datetime
)
WITH (
RETENTION = 3650 DAYS,
CLUSTERED COLUMNSTORE INDEX,
DATA_COMPRESSION = PAGE,
DISTRIBUTION = REPLICATE,
PARTITION (field3 RANGE RIGHT FOR VALUES ('2019-01-01T00:00:00Z', '2020-01-01T00:00:00Z', '2021-01-01T00:00:00Z', '2022-01-01T00:00:00Z'))
);
下一篇:ADX图不清晰