CREATE TABLE `mf_customer_delivery_monitor_org_detail` (
  `rpt_date` date NULL COMMENT "日期",
  `order_channel_code` varchar(100) NULL COMMENT "訂單渠道",
  `order_date` date NULL COMMENT "訂閱日期",
  `region_code` varchar(50) NULL COMMENT "省區(qū)code",
  `region_name` varchar(100) NULL COMMENT "省區(qū)名稱",
  `material_org_code` varchar(50) NULL COMMENT "物料網(wǎng)點code",
  `material_org_name` varchar(100) NULL COMMENT "物料網(wǎng)點名稱",
  `branch_code` varchar(50) NULL COMMENT "分公司code",
  `branch_name` varchar(100) NULL COMMENT "分公司名稱",
  `customer_code` varchar(50) NULL COMMENT "客戶code",
  `customer_name` varchar(100) NULL COMMENT "客戶名稱",
  `seller_id` varchar(50) NULL COMMENT "商家id",
  `seller_name` varchar(100) NULL COMMENT "商家",
  `is_zd` varchar(10) NULL COMMENT "是否參與自動"
) ENGINE=OLAP
DUPLICATE KEY(`rpt_date`, `order_channel_code`)
COMMENT "商家發(fā)貨監(jiān)控網(wǎng)點明細表"
PARTITION BY RANGE(`rpt_date`)
(PARTITION p20221102 VALUES [('2022-11-02'), ('2022-11-03')),
PARTITION p20221103 VALUES [('2022-11-03'), ('2022-11-04')),
PARTITION p20221104 VALUES [('2022-11-04'), ('2022-11-05')))
DISTRIBUTED BY HASH(`rpt_date`) BUCKETS 144
PROPERTIES (
"replication_num" = "3",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.time_zone" = "Asia/Shanghai",
"dynamic_partition.start" = "-60",
"dynamic_partition.end" = "7",
"dynamic_partition.prefix" = "p",
"dynamic_partition.buckets" = "144",
"in_memory" = "false",
"storage_format" = "DEFAULT",
"enable_persistent_index" = "false"
); 

replication_num 副本數(shù)

dynamic_partition.enable 開啟動態(tài)分區(qū)
dynamic_partition.start 動態(tài)分區(qū)的開始時間。以當天為基準，根據(jù)該參數(shù)向過去推算數(shù)個粒度的時間，超過該時間范圍的分區(qū)將會被刪除。如果不填寫，則默認為Integer.MIN_VALUE即-2147483648。
dynamic_partition.end：動態(tài)分區(qū)的結(jié)束時間。以當天為基準，會根據(jù)該參數(shù)提前創(chuàng)建數(shù)個粒度的分區(qū)范圍。

dynamic_partition.prefix：動態(tài)分區(qū)自動創(chuàng)建的分區(qū)名前綴。

dynamic_partition.buckets：動態(tài)創(chuàng)建的分區(qū)所對應(yīng)的分桶數(shù)量。

enable_persistent_index 是否持久化主鍵索引，同時使用磁盤和內(nèi)存存儲主鍵索引，避免主鍵索引占用過大內(nèi)存空間。取值為 true 或者 false。如果磁盤為固態(tài)硬盤 SSD，則建議設(shè)置為 true。自 2.3.0 版本起，StarRocks 支持配置該參數(shù)。