一、背景
智能货物StarRocks集群信息ent3 的集群，3fe+3be， 每个be节点都加了一块SSD数据盘，形成HDD+SSD混合存储。
现在需要将以下涉及的表的有关分区迁移到SSD上。
把ent3的以下表的存储介质从HDD迁移的SSD上
ent3 SR 地址：
172.25.214.48、172.25.214.49、172.25.214.50
需要迁移的表：
ims_store_recipe
cic_storage_record
cic_realstorage_image_info
ims_wdd_basic_material_sale_log
ims_wdd_merchandise_sale_log
时间范围：迁移最近一个月分区和未来所有分区
参考脚本：
ALTER TABLE example_db.my_table
MODIFY PARTITION p_month202308
SET (
"storage_medium" = "SSD",
"storage_cooldown_time" = "2023-09-13 14:50:00"
);
二、涉及的表
-
库名
cic_data_center
-
表
cic_data_center.ims_store_recipe
cic_data_center.cic_storage_record
cic_data_center.cic_realstorage_image_info
cic_data_center.ims_wdd_basic_material_sale_log
cic_data_center.ims_wdd_merchandise_sale_log
cic_data_center.ims_wdd_after_item_sale_log
cic_data_center.ims_ordering_material_mapping
cic_data_center.ims_order_material_mapping
cic_data_center.ims_wdd_standard_product_sale_log
cic_data_center.ims_wdd_merchandise_sale
cic_data_center.ims_order_product_thousand_adjust
cic_data_center.operation_flow_detail
cic_data_center.fcst_store_usage_merchandise
cic_data_center.ims_order_forecast_inventory
cic_data_center.ims_ordering_adjust_record
cic_data_center.cic_quality_operate_log
cic_data_center.ims_wdd_after_item_sale
cic_data_center.ims_order_forecast_warning
cic_data_center.cic_realstorage_info
cic_data_center.cic_quality_expire
三、操作
-
cic_data_center.ims_store_recipe
表结构
show create table cic_data_center.ims_store_recipe\G
*************************** 1. row ***************************
Table : ims_store_recipe
Create Table: CREATE TABLE `ims_store_recipe` (
`brand_code` tinyint(4) NOT NULL COMMENT "品牌编码",
`store_code` varchar(64) NOT NULL COMMENT "门店编号",
`business_date` date NOT NULL COMMENT "业务日 yyyy-mm-dd",
`standard_product_code` varchar(64) NOT NULL COMMENT "标准品编码",
`basic_material_code` varchar(64) NOT NULL COMMENT "原物料编码",
`bm_amount` decimal128(20, 6) NOT NULL COMMENT "原物料数量",
`recipe_code` varchar(64) NOT NULL COMMENT "配方编码",
`version_no` varchar(64) NULL COMMENT "",
`last_update_time` varchar(64) NOT NULL COMMENT "最近更新时间"
) ENGINE=OLAP
DUPLICATE KEY(`brand_code`, `store_code`, `business_date`, `standard_product_code`)
COMMENT "OLAP"
PARTITION BY RANGE(`business_date`)
(PARTITION p_month202406 VALUES [("2024-06-01"), ("2024-07-01")),
PARTITION p_month202407 VALUES [("2024-07-01"), ("2024-08-01")),
PARTITION p_month202408 VALUES [("2024-08-01"), ("2024-09-01")),
PARTITION p_month202409 VALUES [("2024-09-01"), ("2024-10-01")),
PARTITION p_month202410 VALUES [("2024-10-01"), ("2024-11-01")),
PARTITION p_month202411 VALUES [("2024-11-01"), ("2024-12-01")),
PARTITION p_month202412 VALUES [("2024-12-01"), ("2025-01-01")),
PARTITION p_month202501 VALUES [("2025-01-01"), ("2025-02-01")),
PARTITION p_month202502 VALUES [("2025-02-01"), ("2025-03-01")),
PARTITION p_month202503 VALUES [("2025-03-01"), ("2025-04-01")),
PARTITION p_month202504 VALUES [("2025-04-01"), ("2025-05-01")),
PARTITION p_month202505 VALUES [("2025-05-01"), ("2025-06-01")),
PARTITION p_month202506 VALUES [("2025-06-01"), ("2025-07-01")),
PARTITION p_month202507 VALUES [("2025-07-01"), ("2025-08-01")),
PARTITION p_month202508 VALUES [("2025-08-01"), ("2025-09-01")),
PARTITION p_month202509 VALUES [("2025-09-01"), ("2025-10-01")),
PARTITION p_month202510 VALUES [("2025-10-01"), ("2025-11-01")))
DISTRIBUTED BY HASH(`store_code`) BUCKETS 12
PROPERTIES (
"replication_num" = "3",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "MONTH",
"dynamic_partition.time_zone" = "Asia/Shanghai",
"dynamic_partition.start" = "-13",
"dynamic_partition.end" = "3",
"dynamic_partition.prefix" = "p_month",
"dynamic_partition.buckets" = "12",
"dynamic_partition.history_partition_num" = "0",
"dynamic_partition.start_day_of_month" = "1",
"in_memory" = "false",
"storage_format" = "DEFAULT",
"enable_persistent_index" = "false",
"replicated_storage" = "false",
"compression" = "LZ4"
);
1 row in set (0.00 sec)
迁移命令
ALTER TABLE cic_data_center.ims_store_recipe
MODIFY PARTITION p_month202507
SET ("storage_medium" = "SSD", "storage_cooldown_time" = "2025-08-01 14:50:00");
ALTER TABLE cic_data_center.ims_store_recipe
MODIFY PARTITION p_month202508
SET ("storage_medium" = "SSD", "storage_cooldown_time" = "2025-09-01 14:50:00");
ALTER TABLE cic_data_center.ims_store_recipe
MODIFY PARTITION p_month202509
SET ("storage_medium" = "SSD", "storage_cooldown_time" = "2025-10-01 14:50:00");
ALTER TABLE cic_data_center.ims_store_recipe
MODIFY PARTITION p_month202510
SET ("storage_medium" = "SSD", "storage_cooldown_time" = "2025-11-01 14:50:00");
# 验证
SHOW PARTITIONS FROM cic_data_center.ims_store_recipe;
-
cic_data_center.cic_storage_record
表结构
show create table cic_storage_record\G
*************************** 1. row ***************************
Table: cic_storage_record
Create Table: CREATE TABLE `cic_storage_record` (
`brand_code` tinyint(4) NOT NULL COMMENT "品牌编码",
`store_code` varchar(64) NOT NULL COMMENT "门店编号",
`business_date` date NOT NULL COMMENT "业务日 yyyy-mm-dd",
`room_code` varchar(64) NULL COMMENT "仓库位置 鸡库1 菜库2 干货3 冻库4 常温品 5",
`item_code` varchar(64) NULL COMMENT "货品/半成品 编码",
`batch_time` varchar(64) NULL COMMENT "批次时间",
`source` varchar(64) NULL COMMENT "数据来源 1 ims、2 epqc、3 扫码、4 rfid、5统一调拨web服务",
`repeat_record_tag` varchar(64) NULL COMMENT "重复计算流水标识 1非重复 需要计算实时库存 2重复 只记流水不计算实时库存",
`event_record_tag` varchar(64) NULL COMMENT "活动流水标识 1活动流水需要推送至物料计算pulsar topic,2不推送",
`inventory_tag_id` varchar(64) NULL COMMENT "盘点标识，手持机盘点会生成一次盘点标识，并且每个盘点项生成的流水都携带该标识",
`order_no` varchar(64) NULL COMMENT "IMS订单号 重算业务使用",
`batch_code` varchar(200) NULL COMMENT "epqc批次编码",
`available_time` varchar(64) NULL COMMENT "可用时间",
`expired_time` varchar(64) NULL COMMENT "过期时间",
`item_name` varchar(500) NULL COMMENT "货品/半成品 名称",
`stock_classification` varchar(64) NULL COMMENT "入库类型 解冻入库1 进货入库2 预冷入库3",
`stock_classification_name` varchar(64) NULL COMMENT "入库类型名称 解冻入库1 进货入库2 预冷入库3",
`record_classification` varchar(64) NULL COMMENT "+入库 1 -领料 2 +回库 3 +调入 4 -调出 5 +退货 6 -损耗 7 +校准差异 8 扫码盘点9 人工盘点10 售卖流水 11 IMS盘点 12",
`item_type` varchar(64) NULL COMMENT "货品类型 1货品2半成品",
`material_type` varchar(64) NULL COMMENT "1扫码 2RFID",
`unit_code` varchar(64) NULL COMMENT "扫码/包装单位编码",
`unit_name` varchar(64) NULL COMMENT "扫码/包装 单位名称",
`unit_to_min_unit` varchar(64) NULL COMMENT "大小单位转换比例",
`material_origin_unit_code` varchar(64) NULL COMMENT "盘点/配方单位编码",
`material_origin_unit_name` varchar(64) NULL COMMENT "盘点/配方单位名称",
`before_amount` varchar(64) NULL COMMENT "计算前流水量/盘点量",
`after_amount` varchar(64) NULL COMMENT "计算后流水量/盘点量",
`amount` varchar(64) NULL COMMENT "流水量/盘点量",
`processing_time` varchar(64) NULL COMMENT "处理时间",
`merchandise_code` varchar(50) NULL COMMENT "源制作品项",
`inventory_differ` varchar(64) NULL COMMENT "盘点差异量，非盘点流水不携带",
`theory_storage` varchar(64) NULL COMMENT "理论库存",
`differ_type` varchar(64) NULL COMMENT "差异类型 扫码盘点差异 1 人工盘点差异2",
`differ_reason_code` varchar(200) NULL COMMENT "差异原因",
`basicmaterial_code` varchar(64) NULL COMMENT "原物料编码",
`inventory_flow_id` varchar(200) NULL COMMENT "流水id",
`create_time` varchar(64) NULL COMMENT "创建时间",
`create_id` varchar(64) NULL COMMENT "创建人",
`update_time` varchar(64) NULL COMMENT "修改时间",
`update_id` varchar(64) NULL COMMENT "修改人",
`check_flag` varchar(64) NULL COMMENT "标识"
) ENGINE=OLAP
DUPLICATE KEY(`brand_code`, `store_code`, `business_date`, `room_code`, `item_code`, `batch_time`)
COMMENT "OLAP"
PARTITION BY RANGE(`business_date`)
(PARTITION p_month202504 VALUES [("2025-04-01"), ("2025-05-01")),
PARTITION p_month202505 VALUES [("2025-05-01"), ("2025-06-01")),PARTITION p_month202506 VALUES [("2025-06-01"), ("2025-07-01")),PARTITION p_month202507 VALUES [("2025-07-01"), ("2025-08-01")),PARTITION p_month202508 VALUES [("2025-08-01"), ("2025-09-01")),PARTITION p_month202509 VALUES [("2025-09-01"), ("2025-10-01")),PARTITION p_month202510 VALUES [("2025-10-01"), ("2025-11-01")))DISTRIBUTED BY HASH(`store_code`) BUCKETS 72 PROPERTIES ("replication_num" = "3","dynamic_partition.enable" = "true","dynamic_partition.time_unit" = "MONTH","dynamic_partition.time_zone" = "Asia/Shanghai","dynamic_partition.start" = "-3","dynamic_partition.end" = "3","dynamic_partition.prefix" = "p_month","dynamic_partition.buckets" = "72","dynamic_partition.history_partition_num" = "0","dynamic_partition.start_day_of_month" = "1","in_memory" = "false","storage_format" = "DEFAULT","enable_persistent_index" = "false","replicated_storage" = "false","compression" = "LZ4");1 row in set (0.00 sec)迁移命令
ALTER TABLE cic_data_center.cic_storage_record
MODIFY PARTITION p_month202507
SET ("storage_medium" = "SSD", "storage_cooldown_time" = "2025-08-01 14:50:00");
ALTER TABLE cic_data_center.cic_storage_record
MODIFY PARTITION p_month202508
SET ("storage_medium" = "SSD", "storage_cooldown_time" = "2025-09-01 14:50:00");
ALTER TABLE cic_data_center.cic_storage_record
MODIFY PARTITION p_month202509
SET ("storage_medium" = "SSD", "storage_cooldown_time" = "2025-10-01 14:50:00");
ALTER TABLE cic_data_center.cic_storage_record
MODIFY PARTITION p_month202510
SET ("storage_medium" = "SSD", "storage_cooldown_time" = "2025-11-01 14:50:00");
-
cic_data_center.cic_realstorage_image_info
表结构
mysql> show create table cic_data_center.cic_realstorage_image_info\G
*************************** 1. row ***************************
Table: cic_realstorage_image_info
Create Table: CREATE TABLE `cic_realstorage_image_info` (
`brand_code` varchar(10) NOT NULL COMMENT "品牌编号",
`store_code` varchar(50) NOT NULL COMMENT "门店编号",
`business_date` date NOT NULL COMMENT "业务日 yyyy-mm-dd",
`item_code` varchar(64) NOT NULL COMMENT "货品编码",
`room_code` int(11) NOT NULL COMMENT "仓位code",
`item_name` varchar(255) REPLACE_IF_NOT_NULL NULL COMMENT "货品名称",
`room_name` varchar(64) REPLACE_IF_NOT_NULL NULL COMMENT "仓位",
`unit_code` varchar(64) REPLACE_IF_NOT_NULL NULL COMMENT "单位code",
`unit_name` varchar(64) REPLACE_IF_NOT_NULL NULL COMMENT "单位",
`cost_price` decimal128(20, 9) REPLACE_IF_NOT_NULL NULL COMMENT "",
`uom_unit_code` varchar(64) REPLACE_IF_NOT_NULL NULL COMMENT "主计量单位code",
`uom_unit_name` varchar(64) REPLACE_IF_NOT_NULL NULL COMMENT "主计量单位名",
`check_to_uom_unit_rate` varchar(64) REPLACE_IF_NOT_NULL NULL COMMENT "盘点折算单位到主计量单位比例 Y:N",
`order_unit_code` varchar(64) REPLACE_IF_NOT_NULL NULL COMMENT "订货单位code",
`order_unit_name` varchar(64) REPLACE_IF_NOT_NULL NULL COMMENT "订货单位",
`check_amount` decimal128(20, 6) REPLACE_IF_NOT_NULL NULL COMMENT "盘点库存",
`order_to_check_radio` decimal128(20, 6) REPLACE_IF_NOT_NULL NULL COMMENT "箱规",
`compute_mode_name` varchar(64) REPLACE_IF_NOT_NULL NULL COMMENT "计算方式",
`delayed_purchase_amount` decimal128(20, 9) REPLACE_IF_NOT_NULL NULL COMMENT "延时进货数据",
`delayed_return_amount` decimal128(20, 9) REPLACE_IF_NOT_NULL NULL COMMENT "延时退货数据",
`delayed_allot_amount` decimal128(20, 9) REPLACE_IF_NOT_NULL NULL COMMENT "延时调拨数据",
`delayed_loss_amount` decimal128(20, 9) REPLACE_IF_NOT_NULL NULL COMMENT "延时损耗数据",
`create_id` varchar(64) REPLACE_IF_NOT_NULL NULL COMMENT "创建人",
`create_time` datetime REPLACE_IF_NOT_NULL NULL COMMENT "创建时间",
`update_id` varchar(64) REPLACE_IF_NOT_NULL NULL COMMENT "更新人",
`update_time` datetime REPLACE_IF_NOT_NULL NULL COMMENT "更新时间",
`del_flag` varchar(64) REPLACE_IF_NOT_NULL NULL COMMENT "删除标志"
) ENGINE=OLAP
AGGREGATE KEY(`brand_code`, `store_code`, `business_date`, `item_code`, `room_code`)
COMMENT "实时库存镜像表"
PARTITION BY RANGE(`business_date`)
(PARTITION p_month202406 VALUES [("2024-06-01"), ("2024-07-01")),
PARTITION p_month202407 VALUES [("2024-07-01"), ("2024-08-01")), PARTITION p_month202408 VALUES [("2024-08-01"), ("2024-09-01")), PARTITION p_month202409 VALUES [("2024-09-01"), ("2024-10-01")), PARTITION p_month202410 VALUES [("2024-10-01"), ("2024-11-01")), PARTITION p_month202411 VALUES [("2024-11-01"), ("2024-12-01")), PARTITION p_month202412 VALUES [("2024-12-01"), ("2025-01-01")), PARTITION p_month202501 VALUES [("2025-01-01"), ("2025-02-01")), PARTITION p_month202502 VALUES [("2025-02-01"), ("2025-03-01")), PARTITION p_month202503 VALUES [("2025-03-01"), ("2025-04-01")), PARTITION p_month202504 VALUES [("2025-04-01"), ("2025-05-01")), PARTITION p_month202505 VALUES [("2025-05-01"), ("2025-06-01")), PARTITION p_month202506 VALUES [("2025-06-01"), ("2025-07-01")), PARTITION p_month202507 VALUES [("2025-07-01"), ("2025-08-01")), PARTITION p_month202508 VALUES [("2025-08-01"), ("2025-09-01")), PARTITION p_month202509 VALUES [("2025-09-01"), ("2025-10-01")), PARTITION p_month202510 VALUES [("2025-10-01"), ("2025-11-01"))) DISTRIBUTED BY HASH(`store_code`) BUCKETS 36 PROPERTIES ( "replication_num" = "3", "dynamic_partition.enable" = "true", "dynamic_partition.time_unit" = "MONTH", "dynamic_partition.time_zone" = "Asia/Shanghai", "dynamic_partition.start" = "-13", "dynamic_partition.end" = "3", "dynamic_partition.prefix" = "p_month", "dynamic_partition.buckets" = "36", "dynamic_partition.history_partition_num" = "0", "dynamic_partition.start_day_of_month" = "1", "in_memory" = "false", "storage_format" = "DEFAULT", "enable_persistent_index" = "false", "replicated_storage" = "false", "compression" = "LZ4" ); 1 row in set (0.00 sec)迁移命令
ALTER TABLE cic_data_center.cic_realstorage_image_info
MODIFY PARTITION p_month202507
SET ("storage_medium" = "SSD", "storage_cooldown_time" = "2025-08-01 14:50:00");
ALTER TABLE cic_data_center.cic_realstorage_image_info
MODIFY PARTITION p_month202508
SET ("storage_medium" = "SSD", "storage_cooldown_time" = "2025-09-01 14:50:00");
ALTER TABLE cic_data_center.cic_realstorage_image_info
MODIFY PARTITION p_month202509
SET ("storage_medium" = "SSD", "storage_cooldown_time" = "2025-10-01 14:50:00");
ALTER TABLE cic_data_center.cic_realstorage_image_info
MODIFY PARTITION p_month202510
SET ("storage_medium" = "SSD", "storage_cooldown_time" = "2025-11-01 14:50:00");
#
SHOW PARTITIONS FROM cic_data_center.cic_realstorage_image_info;
-
cic_data_center.ims_wdd_basic_material_sale_log
表结构
mysql> show create table cic_data_center.ims_wdd_basic_material_sale_log\G
*************************** 1. row ***************************
Table: ims_wdd_basic_material_sale_log
Create Table: CREATE TABLE `ims_wdd_basic_material_sale_log` (
`brand_code` tinyint(4) NOT NULL COMMENT "品牌编码",
`store_code` varchar(64) NOT NULL COMMENT "门店编号",
`business_date` date NOT NULL COMMENT "业务日 yyyy-mm-dd",
`basic_material_code` varchar(64) NOT NULL COMMENT "原物料编码",
`order_type_name` varchar(64) NULL COMMENT "交易状态",
`order_type` varchar(64) NULL COMMENT "订单类型",
`order_number` varchar(64) NULL COMMENT "订单编号",
`quantity` decimal128(20, 6) NULL COMMENT "数量",
`standard_quantity` decimal128(20, 6) NULL COMMENT "标准数量",
`recipe_unit_code` varchar(64) NULL COMMENT "配方单位",
`plat_type` varchar(64) NULL COMMENT "渠道",
`sale_terminal_id` varchar(64) NULL COMMENT "收银机编号",
`big_order` varchar(64) NULL COMMENT "是否大单",
`channel_id` varchar(64) NULL COMMENT "渠道 ID",
`natural_date` varchar(64) NULL COMMENT "自然日期",
`location_id` varchar(64) NULL COMMENT "交易地点",
`sale_operator_id` varchar(64) NULL COMMENT "收银员",
`sale_type` varchar(64) NULL COMMENT "销售类型",
`send_to_kitchen_time` varchar(64) NULL COMMENT "发到后厨时间",
`new_business_type` varchar(64) NULL COMMENT "新交易类型",
`business_type` varchar(64) NULL COMMENT "交易类型",
`delivery_promise_time` varchar(64) NULL COMMENT "承诺到达时间",
`trans_time` varchar(64) NULL COMMENT "交易发起时间",
`order_open_time` varchar(64) NULL COMMENT "开单时间(自然时间）",
`tender_time` varchar(64) NULL COMMENT "结算时间(自然时间）",
`process_timestamp` varchar(64) NULL COMMENT "拆解时间"
) ENGINE=OLAP
DUPLICATE KEY(`brand_code`, `store_code`, `business_date`, `basic_material_code`)
COMMENT "OLAP"
PARTITION BY RANGE(`business_date`)
(PARTITION p20250516 VALUES [("2025-05-16"), ("2025-05-17")),
PARTITION p20250517 VALUES [("2025-05-17"), ("2025-05-18")), PARTITION p20250518 VALUES [("2025-05-18"), ("2025-05-19")), PARTITION p20250519 VALUES [("2025-05-19"), ("2025-05-20")), PARTITION p20250520 VALUES [("2025-05-20"), ("2025-05-21")), PARTITION p20250521 VALUES [("2025-05-21"), ("2025-05-22")), PARTITION p20250522 VALUES [("2025-05-22"), ("2025-05-23")), PARTITION p20250523 VALUES [("2025-05-23"), ("2025-05-24")), PARTITION p20250524 VALUES [("2025-05-24"), ("2025-05-25")), PARTITION p20250525 VALUES [("2025-05-25"), ("2025-05-26")), PARTITION p20250526 VALUES [("2025-05-26"), ("2025-05-27")), PARTITION p20250527 VALUES [("2025-05-27"), ("2025-05-28")), PARTITION p20250528 VALUES [("2025-05-28"), ("2025-05-29")), PARTITION p20250529 VALUES [("2025-05-29"), ("2025-05-30")), PARTITION p20250530 VALUES [("2025-05-30"), ("2025-05-31")), PARTITION p20250531 VALUES [("2025-05-31"), ("2025-06-01")), PARTITION p20250601 VALUES [("2025-06-01"), ("2025-06-02")), PARTITION p20250602 VALUES [("2025-06-02"), ("2025-06-03")), PARTITION p20250603 VALUES [("2025-06-03"), ("2025-06-04")), PARTITION p20250604 VALUES [("2025-06-04"), ("2025-06-05")), PARTITION p20250605 VALUES [("2025-06-05"), ("2025-06-06")), PARTITION p20250606 VALUES [("2025-06-06"), ("2025-06-07")), PARTITION p20250607 VALUES [("2025-06-07"), ("2025-06-08")), PARTITION p20250608 VALUES [("2025-06-08"), ("2025-06-09")), PARTITION p20250609 VALUES [("2025-06-09"), ("2025-06-10")), PARTITION p20250610 VALUES [("2025-06-10"), ("2025-06-11")), PARTITION p20250611 VALUES [("2025-06-11"), ("2025-06-12")), PARTITION p20250612 VALUES [("2025-06-12"), ("2025-06-13")), PARTITION p20250613 VALUES [("2025-06-13"), ("2025-06-14")), PARTITION p20250614 VALUES [("2025-06-14"), ("2025-06-15")), PARTITION p20250615 VALUES [("2025-06-15"), ("2025-06-16")), PARTITION p20250616 VALUES [("2025-06-16"), ("2025-06-17")), PARTITION p20250617 VALUES [("2025-06-17"), ("2025-06-18")), PARTITION p20250618 VALUES [("2025-06-18"), ("2025-06-19")), PARTITION p20250619 VALUES [("2025-06-19"), ("2025-06-20")), PARTITION p20250620 VALUES [("2025-06-20"), ("2025-06-21")), PARTITION p20250621 VALUES [("2025-06-21"), ("2025-06-22")), PARTITION p20250622 VALUES [("2025-06-22"), ("2025-06-23")), PARTITION p20250623 VALUES [("2025-06-23"), ("2025-06-24")), PARTITION p20250624 VALUES [("2025-06-24"), ("2025-06-25")), PARTITION p20250625 VALUES [("2025-06-25"), ("2025-06-26")), PARTITION p20250626 VALUES [("2025-06-26"), ("2025-06-27")), PARTITION p20250627 VALUES [("2025-06-27"), ("2025-06-28")), PARTITION p20250628 VALUES [("2025-06-28"), ("2025-06-29")), PARTITION p20250629 VALUES [("2025-06-29"), ("2025-06-30")), PARTITION p20250630 VALUES [("2025-06-30"), ("2025-07-01")), PARTITION p20250701 VALUES [("2025-07-01"), ("2025-07-02")), PARTITION p20250702 VALUES [("2025-07-02"), ("2025-07-03")), PARTITION p20250703 VALUES [("2025-07-03"), ("2025-07-04")), PARTITION p20250704 VALUES [("2025-07-04"), ("2025-07-05")), PARTITION p20250705 VALUES [("2025-07-05"), ("2025-07-06")), PARTITION p20250706 VALUES [("2025-07-06"), ("2025-07-07")), PARTITION p20250707 VALUES [("2025-07-07"), ("2025-07-08")), PARTITION p20250708 VALUES [("2025-07-08"), ("2025-07-09")), PARTITION p20250709 VALUES [("2025-07-09"), ("2025-07-10")), PARTITION p20250710 VALUES [("2025-07-10"), ("2025-07-11")), PARTITION p20250711 VALUES [("2025-07-11"), ("2025-07-12")), PARTITION p20250712 VALUES [("2025-07-12"), ("2025-07-13")), PARTITION p20250713 VALUES [("2025-07-13"), ("2025-07-14")), PARTITION p20250714 VALUES [("2025-07-14"), ("2025-07-15")), PARTITION p20250715 VALUES [("2025-07-15"), ("2025-07-16")), PARTITION p20250716 VALUES [("2025-07-16"), ("2025-07-17")), PARTITION p20250717 VALUES [("2025-07-17"), ("2025-07-18")), PARTITION p20250718 VALUES [("2025-07-18"), ("2025-07-19")), PARTITION p20250719 VALUES [("2025-07-19"), ("2025-07-20")), PARTITION p20250720 VALUES [("2025-07-20"), ("2025-07-21"))) DISTRIBUTED BY HASH(`store_code`) BUCKETS 12 PROPERTIES ( "replication_num" = "3", "dynamic_partition.enable" = "true", "dynamic_partition.time_unit" = "DAY", "dynamic_partition.time_zone" = "Asia/Shanghai", "dynamic_partition.start" = "-62", "dynamic_partition.end" = "3", "dynamic_partition.prefix" = "p", "dynamic_partition.buckets" = "12", "dynamic_partition.history_partition_num" = "0", "in_memory" = "false", "storage_format" = "DEFAULT", "enable_persistent_index" = "false", "replicated_storage" = "false", "compression" = "LZ4" ); 1 row in set (0.00 sec)迁移命令
ALTER TABLE cic_data_center.ims_wdd_basic_material_sale_log
MODIFY PARTITION p20250701
SET ("storage_medium" = "SSD", "storage_cooldown_time" = "2025-08-01 14:50:00");
ALTER TABLE cic_data_center.ims_wdd_basic_material_sale_log
MODIFY PARTITION p20250702
SET ("storage_medium" = "SSD", "storage_cooldown_time" = "2025-08-02 14:50:00");
ALTER TABLE cic_data_center.ims_wdd_basic_material_sale_log
MODIFY PARTITION p20250703
SET ("storage_medium" = "SSD", "storage_cooldown_time" = "2025-08-03 14:50:00");
ALTER TABLE cic_data_center.ims_wdd_basic_material_sale_log
MODIFY PARTITION p20250704
SET ("storage_medium" = "SSD", "storage_cooldown_time" = "2025-08-04 14:50:00");
ALTER TABLE cic_data_center.ims_wdd_basic_material_sale_log
MODIFY PARTITION p20250705
SET ("storage_medium" = "SSD", "storage_cooldown_time" = "2025-08-05 14:50:00");
ALTER TABLE cic_data_center.ims_wdd_basic_material_sale_log
MODIFY PARTITION p20250706
SET ("storage_medium" = "SSD", "storage_cooldown_time" = "2025-08-06 14:50:00");
ALTER TABLE cic_data_center.ims_wdd_basic_material_sale_log
MODIFY PARTITION p20250707
SET ("storage_medium" = "SSD", "storage_cooldown_time" = "2025-08-07 14:50:00");
ALTER TABLE cic_data_center.ims_wdd_basic_material_sale_log
MODIFY PARTITION p20250708
SET ("storage_medium" = "SSD", "storage_cooldown_time" = "2025-08-08 14:50:00");
ALTER TABLE cic_data_center.ims_wdd_basic_material_sale_log
MODIFY PARTITION p20250709
SET ("storage_medium" = "SSD", "storage_cooldown_time" = "2025-08-09 14:50:00");
ALTER TABLE cic_data_center.ims_wdd_basic_material_sale_log
MODIFY PARTITION p20250710
SET ("storage_medium" = "SSD", "storage_cooldown_time" = "2025-08-10 14:50:00");
ALTER TABLE cic_data_center.ims_wdd_basic_material_sale_log
MODIFY PARTITION p20250711
SET ("storage_medium" = "SSD", "storage_cooldown_time" = "2025-08-11 14:50:00");
ALTER TABLE cic_data_center.ims_wdd_basic_material_sale_log
MODIFY PARTITION p20250712
SET ("storage_medium" = "SSD", "storage_cooldown_time" = "2025-08-12 14:50:00");
ALTER TABLE cic_data_center.ims_wdd_basic_material_sale_log
MODIFY PARTITION p20250713
SET ("storage_medium" = "SSD", "storage_cooldown_time" = "2025-08-13 14:50:00");
ALTER TABLE cic_data_center.ims_wdd_basic_material_sale_log
MODIFY PARTITION p20250714
SET ("storage_medium" = "SSD", "storage_cooldown_time" = "2025-08-14 14:50:00");
ALTER TABLE cic_data_center.ims_wdd_basic_material_sale_log
MODIFY PARTITION p20250715
SET ("storage_medium" = "SSD", "storage_cooldown_time" = "2025-08-15 14:50:00");
ALTER TABLE cic_data_center.ims_wdd_basic_material_sale_log
MODIFY PARTITION p20250716
SET ("storage_medium" = "SSD", "storage_cooldown_time" = "2025-08-16 14:50:00");
ALTER TABLE cic_data_center.ims_wdd_basic_material_sale_log
MODIFY PARTITION p20250717
SET ("storage_medium" = "SSD", "storage_cooldown_time" = "2025-08-17 14:50:00");
ALTER TABLE cic_data_center.ims_wdd_basic_material_sale_log
MODIFY PARTITION p20250718
SET ("storage_medium" = "SSD", "storage_cooldown_time" = "2025-08-18 14:50:00");
ALTER TABLE cic_data_center.ims_wdd_basic_material_sale_log
MODIFY PARTITION p20250719
SET ("storage_medium" = "SSD", "storage_cooldown_time" = "2025-08-19 14:50:00");
ALTER TABLE cic_data_center.ims_wdd_basic_material_sale_log
MODIFY PARTITION p20250720
SET ("storage_medium" = "SSD", "storage_cooldown_time" = "2025-08-20 14:50:00");
-
cic_data_center.ims_wdd_merchandise_sale_log
表结构
show create table cic_data_center.ims_wdd_merchandise_sale_log\G
迁移命令
四、补充
、补充
- 参考官方文档
docs.starrocks.io/zh/docs/2.5…
docs.starrocks.io/zh/docs/2.5…
