jollygrass commented on issue #65962:
URL: https://github.com/apache/doris/issues/65962#issuecomment-5065045055
CREATE TABLE `dim_fn_f_month` (
`dt` date NULL COMMENT "分区",
`monthid` decimal(27,0) NULL COMMENT "月份ID",
`monthcode` text NULL COMMENT "月份编码",
`monthname` text NULL COMMENT "月份名称",
`quarterid` decimal(27,0) NULL COMMENT "季度ID",
`yearid` decimal(27,0) NULL COMMENT "年份ID",
`data_create_date` datetime NULL COMMENT "数据入库时间",
`data_update_date` datetime NULL COMMENT "数据修改时间",
`data_status` text NULL COMMENT "数据状态",
`dw_batchno` largeint NULL COMMENT "批次号"
) ENGINE=OLAP
DUPLICATE KEY(`dt`, `monthid`)
COMMENT '月份映射表'
PARTITION BY RANGE(`dt`)
()
DISTRIBUTED BY HASH(`monthid`) BUCKETS AUTO
PROPERTIES (
"replication_allocation" = "tag.location.default: 2",
"min_load_replica_num" = "1",
"is_being_synced" = "false",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.time_zone" = "Asia/Shanghai",
"dynamic_partition.start" = "-3",
"dynamic_partition.end" = "1",
"dynamic_partition.prefix" = "p",
"dynamic_partition.replication_allocation" = "tag.location.default: 2",
"dynamic_partition.buckets" = "10",
"dynamic_partition.create_history_partition" = "true",
"dynamic_partition.history_partition_num" = "-1",
"dynamic_partition.hot_partition_num" = "0",
"dynamic_partition.reserved_history_periods" = "NULL",
"dynamic_partition.storage_policy" = "",
"storage_medium" = "hdd",
"storage_format" = "V2",
"inverted_index_storage_format" = "V3",
"light_schema_change" = "true",
"disable_auto_compaction" = "false",
"group_commit_interval_ms" = "10000",
"group_commit_data_bytes" = "134217728"
);
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
