大量tablet migrate fiiled报错，请问如何解决

💬 StarRocks 用户问答
#1

【详述】问题详细描述
【背景】做过哪些操作？
【业务影响】
【StarRocks版本】例如：2.1.4
【集群规模】例如：3fe（1 follower+2observer）+8be（fe与be混部）
【机器信息】CPU虚拟核/内存/网卡，例如：40C/128G/万兆
【附件】

请问fe和be后台日志有大量报错信息，fe报错为:
2022-05-12 14:32:28,645 WARN (thrift-server-pool-210847|239761) [MasterImpl.finishTask():159] finish task reports bad. request: TFinishTaskRequest(backend:TBackend(host:10.163.205.86, be_port:9060, http_port:8040), task_type:STORAGE_MEDIUM_MIGRATE, signature:11183949, task_status:TStatus(status_code:RUNTIME_ERROR, error_msgs:[]))
2022-05-12 14:32:28,645 WARN (thrift-server-pool-210847|239761) [MasterImpl.finishStorageMigration():821] tablet migrate failed. signature: 11183949, error msg: []
2022-05-12 14:32:28,645 WARN (thrift-server-pool-212842|241904) [MasterImpl.finishTask():159] finish task reports bad. request: TFinishTaskRequest(backend:TBackend(host:10.163.205.86, be_port:9060, http_port:8040), task_type:STORAGE_MEDIUM_MIGRATE, signature:11186506, task_status:TStatus(status_code:RUNTIME_ERROR, error_msgs:[]))
2022-05-12 14:32:28,645 WARN (thrift-server-pool-212842|241904) [MasterImpl.finishStorageMigration():821] tablet migrate failed. signature: 11186506, error msg: []
2022-05-12 14:32:28,645 WARN (thrift-server-pool-1787044|2034255) [MasterImpl.finishTask():159] finish task reports bad. request: TFinishTaskRequest(backend:TBackend(host:10.163.205.86, be_port:9060, http_port:8040), task_type:STORAGE_MEDIUM_MIGRATE, signature:11187035, task_status:TStatus(status_code:RUNTIME_ERROR, error_msgs:[]))
2022-05-12 14:32:28,645 WARN (thrift-server-pool-1787044|2034255) [MasterImpl.finishStorageMigration():821] tablet migrate failed. signature: 11187035, error msg: []
2022-05-12 14:32:28,645 WARN (thrift-server-pool-214415|243540) [MasterImpl.finishTask():159] finish task reports bad. request: TFinishTaskRequest(backend:TBackend(host:10.163.205.86, be_port:9060, http_port:8040), task_type:STORAGE_MEDIUM_MIGRATE, signature:11186528, task_status:TStatus(status_code:RUNTIME_ERROR, error_msgs:[]))
2022-05-12 14:32:28,646 WARN (thrift-server-pool-214415|243540) [MasterImpl.finishStorageMigration():821] tablet migrate failed. signature: 11186528, error msg: []
2022-05-12 14:32:28,646 WARN (thrift-server-pool-210560|239425) [MasterImpl.finishTask():159] finish task reports bad. request: TFinishTaskRequest(backend:TBackend(host:10.163.205.86, be_port:9060, http_port:8040), task_type:STORAGE_MEDIUM_MIGRATE, signature:11186515, task_status:TStatus(status_code:RUNTIME_ERROR, error_msgs:[]))

be报错为：
/root/starrocks/be/src/storage/storage_engine.cpp:980 task->execute(), signature: 11186536
W0512 14:32:16.698158 6295 engine_storage_migration_task.cpp:44] Not support to migrate updatable tablet: 11186515
W0512 14:32:16.698164 6295 task_worker_pool.cpp:1125] storage media migrate failed. status: Not supported: Not support to migrate updatable tablet: 11186515
/root/starrocks/be/src/storage/storage_engine.cpp:980 task->execute(), signature: 11186515
W0512 14:32:16.698257 6295 engine_storage_migration_task.cpp:44] Not support to migrate updatable tablet: 11186008
W0512 14:32:16.698263 6295 task_worker_pool.cpp:1125] storage media migrate failed. status: Not supported: Not support to migrate updatable tablet: 11186008
/root/starrocks/be/src/storage/storage_engine.cpp:980 task->execute(), signature: 11186008
W0512 14:32:16.698349 6295 engine_storage_migration_task.cpp:44] Not support to migrate updatable tablet: 11186016
W0512 14:32:16.698364 6295 task_worker_pool.cpp:1125] storage media migrate failed. status: Not supported: Not support to migrate updatable tablet: 11186016
/root/starrocks/be/src/storage/storage_engine.cpp:980 task->execute(), signature: 11186016
W0512 14:32:17.306970 23725 thread.cpp:221] failed to set thread name: UpdateApplyThreadPool
W0512 14:32:22.874222 23834 thread.cpp:221] failed to set thread name: UpdateApplyThreadPool
W0512 14:32:23.492120 23840 thread.cpp:221] failed to set thread name: UpdateApplyThreadPool
W0512 14:32:23.754092 6153 fragment_mgr.cpp:193] Fail to open fragment 48808926-d1bd-11ec-8fbf-00163e046b40: Cancelled: Cancelled because of runtime state is cancelled
/root/starrocks/be/src/runtime/plan_fragment_executor.cpp:329 _plan->get_next(_runtime_state, &_chunk, &_done)
/root/starrocks/be/src/runtime/plan_fragment_executor.cpp:217 _get_next_internal_vectorized(&chunk)
W0512 14:32:24.169946 23842 thread.cpp:221] failed to set thread name: UpdateApplyThreadPool
W0512 14:32:24.567929 23877 thread.cpp:221] failed to set thread name: UpdateApplyThreadPool
W0512 14:32:24.568527 23878 thread.cpp:221] failed to set thread name: UpdateApplyThreadPool
W0512 14:32:24.759835 23879 thread.cpp:221] failed to set thread name: UpdateApplyThreadPool
W0512 14:32:27.684108 23885 thread.cpp:221] failed to set thread name: UpdateApplyThreadPool
W0512 14:32:28.798442 23887 thread.cpp:221] failed to set thread name: UpdateApplyThreadPool
W0512 14:32:29.464730 23904 thread.cpp:221] failed to set thread name: UpdateApplyThreadPool
W0512 14:32:29.464766 23905 thread.cpp:221] failed to set thread name: UpdateApplyThreadPool
W0512 14:32:31.789280 23907 thread.cpp:221] failed to set thread name: UpdateApplyThreadPool
W0512 14:32:35.914544 23908 thread.cpp:221] failed to set thread name: UpdateApplyThreadPool
W0512 14:32:37.581693 23911 thread.cpp:221] failed to set thread name: UpdateApplyThreadPool
W0512 14:32:38.732424 23913 thread.cpp:221] failed to set thread name: UpdateApplyThreadPool
E0512 14:32:38.757457 6039 olap_scan_node.cpp:259] [TUniqueId(hi=5870203218830365164, lo=-8088746310204363969)] Cancelled: canceled state
W0512 14:32:38.757493 6129 fragment_mgr.cpp:193] Fail to open fragment 517726b9-d1bd-11ec-8fbf-00163e046b41: Cancelled: Cancelled because of runtime state is cancelled
/root/starrocks/be/src/exec/vectorized/cross_join_node.cpp:46 child(0)->open(state)
/root/starrocks/be/src/exec/vectorized/project_node.cpp:94 _children[0]->open(state)
/root/starrocks/be/src/runtime/plan_fragment_executor.cpp:203 _plan->open(_runtime_state)
W0512 14:32:39.342391 23914 thread.cpp:221] failed to set thread name: UpdateApplyThreadPool
W0512 14:32:40.330109 23915 thread.cpp:221] failed to set thread name: UpdateApplyThreadPool
E0512 14:32:44.364233 6027 olap_scan_node.cpp:259] [TUniqueId(hi=6098094814916317676, lo=-8088746310204363969)] Cancelled: canceled state
W0512 14:32:44.365490 6133 fragment_mgr.cpp:193] Fail to open fragment 54a0c8ec-d1bd-11ec-8fbf-00163e046b41: Cancelled: Cancelled because of runtime state is cancelled
/root/starrocks/be/src/runtime/plan_fragment_executor.cpp:329 _plan->get_next(_runtime_state, &_chunk, &_done)
/root/starrocks/be/src/runtime/plan_fragment_executor.cpp:217 _get_next_internal_vectorized(&chunk)
W0512 14:32:45.876835 23926 thread.cpp:221] failed to set thread name: UpdateApplyThreadPool
W0512 14:32:46.359879 23928 thread.cpp:221] failed to set thread name: UpdateApplyThreadPool
W0512 14:32:52.714206 23979 thread.cpp:221] failed to set thread name: UpdateApplyThreadPool
W0512 14:32:53.531081 23983 thread.cpp:221] failed to set thread name: UpdateApplyThreadPool

每天都在不停的报，但貌似没影响使用
请问这些报错是什么意思？会造成什么影响？

#2

这个报错应该是你的表的磁盘属性配置的有问题。节点的磁盘是ssd? show tablet 731433;查看下这个tablet所在表建表时指定的磁盘属性。

#3

感谢，我们是ssd+hdd方式部署
show tablet 731433; 执行后显示如下

image
image1568×83 8.14 KB

再执行 SHOW PROC ‘/dbs/-1/-1/partitions/-1/-1/731433’; 报错
SQL 错误 [1064] [42000]: Database[-1] does not exist.
貌似tablet找不到表信息了

#4

show tablet 11186016;执行这个

#5

对，这个表在ssd，并且目前是空的

#6

然后be关于磁盘的配置是
storage_root_path = /bigdatassd/starrocks/,medium:ssd,400;/bigdatahd/starrocks/,medium:hdd,900

#7

11186515，11186515 show tablet tabletid;查看下这两个tablet 也是同一个表么？这个表的建表语句发下。

#8

是同一张表，还是都是这张空表，建表语句如下：

CREATE TABLE ads_gy_nxck (
di_etl_date datetime NOT NULL ,
id varchar(100) NOT NULL ,
baseName varchar(100) NULL ,
baseCode varchar(100) NULL ,
factoryCode varchar(100) NULL ,
pointCode varchar(100) NULL ,
hbdh varchar(100) NULL ,
tdn varchar(100) NULL ,
dn1 varchar(100) NULL ,
fyfs varchar(100) NULL ,
carNo varchar(100) NULL ,
status varchar(100) NULL ,
productCode varchar(100) ,
productName varchar(100) ,
qty varchar(100) NULL ,
pointName varchar(100) ,
ckmz varchar(100) NULL ,
expect varchar(100) NULL ,
onlineProductQty varchar(100) NULL ,
todayPlanQty varchar(100) NULL ,
tomorrowPlanQty varchar(100) NULL ,
planFahuoTime datetime NULL ,
waitingDuration varchar(100) NULL
) ENGINE=OLAP
PRIMARY KEY(di_etl_date, id)
COMMENT “OLAP”
PARTITION BY RANGE(di_etl_date)
(PARTITION p20220512 VALUES [(‘2022-05-12 00:00:00’), (‘2022-05-13 00:00:00’)),
PARTITION p20220513 VALUES [(‘2022-05-13 00:00:00’), (‘2022-05-14 00:00:00’)),
PARTITION p20220514 VALUES [(‘2022-05-14 00:00:00’), (‘2022-05-15 00:00:00’)),
PARTITION p20220515 VALUES [(‘2022-05-15 00:00:00’), (‘2022-05-16 00:00:00’)),
PARTITION p20220516 VALUES [(‘2022-05-16 00:00:00’), (‘2022-05-17 00:00:00’)),
PARTITION p20220517 VALUES [(‘2022-05-17 00:00:00’), (‘2022-05-18 00:00:00’)),
PARTITION p20220518 VALUES [(‘2022-05-18 00:00:00’), (‘2022-05-19 00:00:00’)),
PARTITION p20220519 VALUES [(‘2022-05-19 00:00:00’), (‘2022-05-20 00:00:00’)),
PARTITION p20220520 VALUES [(‘2022-05-20 00:00:00’), (‘2022-05-21 00:00:00’)),
PARTITION p20220521 VALUES [(‘2022-05-21 00:00:00’), (‘2022-05-22 00:00:00’)),
PARTITION p20220522 VALUES [(‘2022-05-22 00:00:00’), (‘2022-05-23 00:00:00’)),
PARTITION p20220523 VALUES [(‘2022-05-23 00:00:00’), (‘2022-05-24 00:00:00’)),
PARTITION p20220524 VALUES [(‘2022-05-24 00:00:00’), (‘2022-05-25 00:00:00’)),
PARTITION p20220525 VALUES [(‘2022-05-25 00:00:00’), (‘2022-05-26 00:00:00’)),
PARTITION p20220526 VALUES [(‘2022-05-26 00:00:00’), (‘2022-05-27 00:00:00’)),
PARTITION p20220527 VALUES [(‘2022-05-27 00:00:00’), (‘2022-05-28 00:00:00’)),
PARTITION p20220528 VALUES [(‘2022-05-28 00:00:00’), (‘2022-05-29 00:00:00’)),
PARTITION p20220529 VALUES [(‘2022-05-29 00:00:00’), (‘2022-05-30 00:00:00’)),
PARTITION p20220530 VALUES [(‘2022-05-30 00:00:00’), (‘2022-05-31 00:00:00’)),
PARTITION p20220531 VALUES [(‘2022-05-31 00:00:00’), (‘2022-06-01 00:00:00’)),
PARTITION p20220601 VALUES [(‘2022-06-01 00:00:00’), (‘2022-06-02 00:00:00’)),
PARTITION p20220602 VALUES [(‘2022-06-02 00:00:00’), (‘2022-06-03 00:00:00’)),
PARTITION p20220603 VALUES [(‘2022-06-03 00:00:00’), (‘2022-06-04 00:00:00’)),
PARTITION p20220604 VALUES [(‘2022-06-04 00:00:00’), (‘2022-06-05 00:00:00’)),
PARTITION p20220605 VALUES [(‘2022-06-05 00:00:00’), (‘2022-06-06 00:00:00’)),
PARTITION p20220606 VALUES [(‘2022-06-06 00:00:00’), (‘2022-06-07 00:00:00’)),
PARTITION p20220607 VALUES [(‘2022-06-07 00:00:00’), (‘2022-06-08 00:00:00’)),
PARTITION p20220608 VALUES [(‘2022-06-08 00:00:00’), (‘2022-06-09 00:00:00’)),
PARTITION p20220609 VALUES [(‘2022-06-09 00:00:00’), (‘2022-06-10 00:00:00’)),
PARTITION p20220610 VALUES [(‘2022-06-10 00:00:00’), (‘2022-06-11 00:00:00’)),
PARTITION p20220611 VALUES [(‘2022-06-11 00:00:00’), (‘2022-06-12 00:00:00’)),
PARTITION p20220612 VALUES [(‘2022-06-12 00:00:00’), (‘2022-06-13 00:00:00’)),
PARTITION p20220613 VALUES [(‘2022-06-13 00:00:00’), (‘2022-06-14 00:00:00’)),
PARTITION p20220614 VALUES [(‘2022-06-14 00:00:00’), (‘2022-06-15 00:00:00’)),
PARTITION p20220615 VALUES [(‘2022-06-15 00:00:00’), (‘2022-06-16 00:00:00’)),
PARTITION p20220616 VALUES [(‘2022-06-16 00:00:00’), (‘2022-06-17 00:00:00’)),
PARTITION p20220617 VALUES [(‘2022-06-17 00:00:00’), (‘2022-06-18 00:00:00’)),
PARTITION p20220618 VALUES [(‘2022-06-18 00:00:00’), (‘2022-06-19 00:00:00’)),
PARTITION p20220619 VALUES [(‘2022-06-19 00:00:00’), (‘2022-06-20 00:00:00’)),
PARTITION p20220620 VALUES [(‘2022-06-20 00:00:00’), (‘2022-06-21 00:00:00’)),
PARTITION p20220621 VALUES [(‘2022-06-21 00:00:00’), (‘2022-06-22 00:00:00’)),
PARTITION p20220622 VALUES [(‘2022-06-22 00:00:00’), (‘2022-06-23 00:00:00’)),
PARTITION p20220623 VALUES [(‘2022-06-23 00:00:00’), (‘2022-06-24 00:00:00’)),
PARTITION p20220624 VALUES [(‘2022-06-24 00:00:00’), (‘2022-06-25 00:00:00’)),
PARTITION p20220625 VALUES [(‘2022-06-25 00:00:00’), (‘2022-06-26 00:00:00’)),
PARTITION p20220626 VALUES [(‘2022-06-26 00:00:00’), (‘2022-06-27 00:00:00’)),
PARTITION p20220627 VALUES [(‘2022-06-27 00:00:00’), (‘2022-06-28 00:00:00’)),
PARTITION p20220628 VALUES [(‘2022-06-28 00:00:00’), (‘2022-06-29 00:00:00’)),
PARTITION p20220629 VALUES [(‘2022-06-29 00:00:00’), (‘2022-06-30 00:00:00’)),
PARTITION p20220630 VALUES [(‘2022-06-30 00:00:00’), (‘2022-07-01 00:00:00’)),
PARTITION p20220701 VALUES [(‘2022-07-01 00:00:00’), (‘2022-07-02 00:00:00’)),
PARTITION p20220702 VALUES [(‘2022-07-02 00:00:00’), (‘2022-07-03 00:00:00’)),
PARTITION p20220703 VALUES [(‘2022-07-03 00:00:00’), (‘2022-07-04 00:00:00’)),
PARTITION p20220704 VALUES [(‘2022-07-04 00:00:00’), (‘2022-07-05 00:00:00’)),
PARTITION p20220705 VALUES [(‘2022-07-05 00:00:00’), (‘2022-07-06 00:00:00’)),
PARTITION p20220706 VALUES [(‘2022-07-06 00:00:00’), (‘2022-07-07 00:00:00’)),
PARTITION p20220707 VALUES [(‘2022-07-07 00:00:00’), (‘2022-07-08 00:00:00’)),
PARTITION p20220708 VALUES [(‘2022-07-08 00:00:00’), (‘2022-07-09 00:00:00’)),
PARTITION p20220709 VALUES [(‘2022-07-09 00:00:00’), (‘2022-07-10 00:00:00’)),
PARTITION p20220710 VALUES [(‘2022-07-10 00:00:00’), (‘2022-07-11 00:00:00’)),
PARTITION p20220711 VALUES [(‘2022-07-11 00:00:00’), (‘2022-07-12 00:00:00’)),
PARTITION p20220712 VALUES [(‘2022-07-12 00:00:00’), (‘2022-07-13 00:00:00’)),
PARTITION p20220713 VALUES [(‘2022-07-13 00:00:00’), (‘2022-07-14 00:00:00’)),
PARTITION p20220714 VALUES [(‘2022-07-14 00:00:00’), (‘2022-07-15 00:00:00’)),
PARTITION p20220715 VALUES [(‘2022-07-15 00:00:00’), (‘2022-07-16 00:00:00’)),
PARTITION p20220716 VALUES [(‘2022-07-16 00:00:00’), (‘2022-07-17 00:00:00’)),
PARTITION p20220717 VALUES [(‘2022-07-17 00:00:00’), (‘2022-07-18 00:00:00’)),
PARTITION p20220718 VALUES [(‘2022-07-18 00:00:00’), (‘2022-07-19 00:00:00’)),
PARTITION p20220719 VALUES [(‘2022-07-19 00:00:00’), (‘2022-07-20 00:00:00’)),
PARTITION p20220720 VALUES [(‘2022-07-20 00:00:00’), (‘2022-07-21 00:00:00’)),
PARTITION p20220721 VALUES [(‘2022-07-21 00:00:00’), (‘2022-07-22 00:00:00’)),
PARTITION p20220722 VALUES [(‘2022-07-22 00:00:00’), (‘2022-07-23 00:00:00’)),
PARTITION p20220723 VALUES [(‘2022-07-23 00:00:00’), (‘2022-07-24 00:00:00’)),
PARTITION p20220724 VALUES [(‘2022-07-24 00:00:00’), (‘2022-07-25 00:00:00’)),
PARTITION p20220725 VALUES [(‘2022-07-25 00:00:00’), (‘2022-07-26 00:00:00’)),
PARTITION p20220726 VALUES [(‘2022-07-26 00:00:00’), (‘2022-07-27 00:00:00’)),
PARTITION p20220727 VALUES [(‘2022-07-27 00:00:00’), (‘2022-07-28 00:00:00’)),
PARTITION p20220728 VALUES [(‘2022-07-28 00:00:00’), (‘2022-07-29 00:00:00’)),
PARTITION p20220729 VALUES [(‘2022-07-29 00:00:00’), (‘2022-07-30 00:00:00’)),
PARTITION p20220730 VALUES [(‘2022-07-30 00:00:00’), (‘2022-07-31 00:00:00’)),
PARTITION p20220731 VALUES [(‘2022-07-31 00:00:00’), (‘2022-08-01 00:00:00’)),
PARTITION p20220801 VALUES [(‘2022-08-01 00:00:00’), (‘2022-08-02 00:00:00’)),
PARTITION p20220802 VALUES [(‘2022-08-02 00:00:00’), (‘2022-08-03 00:00:00’)),
PARTITION p20220803 VALUES [(‘2022-08-03 00:00:00’), (‘2022-08-04 00:00:00’)),
PARTITION p20220804 VALUES [(‘2022-08-04 00:00:00’), (‘2022-08-05 00:00:00’)),
PARTITION p20220805 VALUES [(‘2022-08-05 00:00:00’), (‘2022-08-06 00:00:00’)),
PARTITION p20220806 VALUES [(‘2022-08-06 00:00:00’), (‘2022-08-07 00:00:00’)),
PARTITION p20220807 VALUES [(‘2022-08-07 00:00:00’), (‘2022-08-08 00:00:00’)),
PARTITION p20220808 VALUES [(‘2022-08-08 00:00:00’), (‘2022-08-09 00:00:00’)),
PARTITION p20220809 VALUES [(‘2022-08-09 00:00:00’), (‘2022-08-10 00:00:00’)),
PARTITION p20220810 VALUES [(‘2022-08-10 00:00:00’), (‘2022-08-11 00:00:00’)),
PARTITION p20220811 VALUES [(‘2022-08-11 00:00:00’), (‘2022-08-12 00:00:00’)),
PARTITION p20220812 VALUES [(‘2022-08-12 00:00:00’), (‘2022-08-13 00:00:00’)),
PARTITION p20220813 VALUES [(‘2022-08-13 00:00:00’), (‘2022-08-14 00:00:00’)),
PARTITION p20220814 VALUES [(‘2022-08-14 00:00:00’), (‘2022-08-15 00:00:00’)),
PARTITION p20220815 VALUES [(‘2022-08-15 00:00:00’), (‘2022-08-16 00:00:00’)),
PARTITION p20220816 VALUES [(‘2022-08-16 00:00:00’), (‘2022-08-17 00:00:00’)),
PARTITION p20220817 VALUES [(‘2022-08-17 00:00:00’), (‘2022-08-18 00:00:00’)),
PARTITION p20220818 VALUES [(‘2022-08-18 00:00:00’), (‘2022-08-19 00:00:00’)),
PARTITION p20220819 VALUES [(‘2022-08-19 00:00:00’), (‘2022-08-20 00:00:00’)),
PARTITION p20220820 VALUES [(‘2022-08-20 00:00:00’), (‘2022-08-21 00:00:00’)),
PARTITION p20220821 VALUES [(‘2022-08-21 00:00:00’), (‘2022-08-22 00:00:00’)),
PARTITION p20220822 VALUES [(‘2022-08-22 00:00:00’), (‘2022-08-23 00:00:00’)),
PARTITION p20220823 VALUES [(‘2022-08-23 00:00:00’), (‘2022-08-24 00:00:00’)),
PARTITION p20220824 VALUES [(‘2022-08-24 00:00:00’), (‘2022-08-25 00:00:00’)),
PARTITION p20220825 VALUES [(‘2022-08-25 00:00:00’), (‘2022-08-26 00:00:00’)),
PARTITION p20220826 VALUES [(‘2022-08-26 00:00:00’), (‘2022-08-27 00:00:00’)),
PARTITION p20220827 VALUES [(‘2022-08-27 00:00:00’), (‘2022-08-28 00:00:00’)),
PARTITION p20220828 VALUES [(‘2022-08-28 00:00:00’), (‘2022-08-29 00:00:00’)),
PARTITION p20220829 VALUES [(‘2022-08-29 00:00:00’), (‘2022-08-30 00:00:00’)),
PARTITION p20220830 VALUES [(‘2022-08-30 00:00:00’), (‘2022-08-31 00:00:00’)),
PARTITION p20220831 VALUES [(‘2022-08-31 00:00:00’), (‘2022-09-01 00:00:00’)),
PARTITION p20220901 VALUES [(‘2022-09-01 00:00:00’), (‘2022-09-02 00:00:00’)),
PARTITION p20220902 VALUES [(‘2022-09-02 00:00:00’), (‘2022-09-03 00:00:00’)),
PARTITION p20220903 VALUES [(‘2022-09-03 00:00:00’), (‘2022-09-04 00:00:00’)),
PARTITION p20220904 VALUES [(‘2022-09-04 00:00:00’), (‘2022-09-05 00:00:00’)),
PARTITION p20220905 VALUES [(‘2022-09-05 00:00:00’), (‘2022-09-06 00:00:00’)),
PARTITION p20220906 VALUES [(‘2022-09-06 00:00:00’), (‘2022-09-07 00:00:00’)),
PARTITION p20220907 VALUES [(‘2022-09-07 00:00:00’), (‘2022-09-08 00:00:00’)),
PARTITION p20220908 VALUES [(‘2022-09-08 00:00:00’), (‘2022-09-09 00:00:00’)),
PARTITION p20220909 VALUES [(‘2022-09-09 00:00:00’), (‘2022-09-10 00:00:00’)),
PARTITION p20220910 VALUES [(‘2022-09-10 00:00:00’), (‘2022-09-11 00:00:00’)),
PARTITION p20220911 VALUES [(‘2022-09-11 00:00:00’), (‘2022-09-12 00:00:00’)),
PARTITION p20220912 VALUES [(‘2022-09-12 00:00:00’), (‘2022-09-13 00:00:00’)),
PARTITION p20220913 VALUES [(‘2022-09-13 00:00:00’), (‘2022-09-14 00:00:00’)),
PARTITION p20220914 VALUES [(‘2022-09-14 00:00:00’), (‘2022-09-15 00:00:00’)),
PARTITION p20220915 VALUES [(‘2022-09-15 00:00:00’), (‘2022-09-16 00:00:00’)),
PARTITION p20220916 VALUES [(‘2022-09-16 00:00:00’), (‘2022-09-17 00:00:00’)),
PARTITION p20220917 VALUES [(‘2022-09-17 00:00:00’), (‘2022-09-18 00:00:00’)),
PARTITION p20220918 VALUES [(‘2022-09-18 00:00:00’), (‘2022-09-19 00:00:00’)),
PARTITION p20220919 VALUES [(‘2022-09-19 00:00:00’), (‘2022-09-20 00:00:00’)),
PARTITION p20220920 VALUES [(‘2022-09-20 00:00:00’), (‘2022-09-21 00:00:00’)),
PARTITION p20220921 VALUES [(‘2022-09-21 00:00:00’), (‘2022-09-22 00:00:00’)),
PARTITION p20220922 VALUES [(‘2022-09-22 00:00:00’), (‘2022-09-23 00:00:00’)),
PARTITION p20220923 VALUES [(‘2022-09-23 00:00:00’), (‘2022-09-24 00:00:00’)),
PARTITION p20220924 VALUES [(‘2022-09-24 00:00:00’), (‘2022-09-25 00:00:00’)),
PARTITION p20220925 VALUES [(‘2022-09-25 00:00:00’), (‘2022-09-26 00:00:00’)),
PARTITION p20220926 VALUES [(‘2022-09-26 00:00:00’), (‘2022-09-27 00:00:00’)),
PARTITION p20220927 VALUES [(‘2022-09-27 00:00:00’), (‘2022-09-28 00:00:00’)),
PARTITION p20220928 VALUES [(‘2022-09-28 00:00:00’), (‘2022-09-29 00:00:00’)),
PARTITION p20220929 VALUES [(‘2022-09-29 00:00:00’), (‘2022-09-30 00:00:00’)),
PARTITION p20220930 VALUES [(‘2022-09-30 00:00:00’), (‘2022-10-01 00:00:00’)),
PARTITION p20221001 VALUES [(‘2022-10-01 00:00:00’), (‘2022-10-02 00:00:00’)),
PARTITION p20221002 VALUES [(‘2022-10-02 00:00:00’), (‘2022-10-03 00:00:00’)),
PARTITION p20221003 VALUES [(‘2022-10-03 00:00:00’), (‘2022-10-04 00:00:00’)),
PARTITION p20221004 VALUES [(‘2022-10-04 00:00:00’), (‘2022-10-05 00:00:00’)),
PARTITION p20221005 VALUES [(‘2022-10-05 00:00:00’), (‘2022-10-06 00:00:00’)),
PARTITION p20221006 VALUES [(‘2022-10-06 00:00:00’), (‘2022-10-07 00:00:00’)),
PARTITION p20221007 VALUES [(‘2022-10-07 00:00:00’), (‘2022-10-08 00:00:00’)),
PARTITION p20221008 VALUES [(‘2022-10-08 00:00:00’), (‘2022-10-09 00:00:00’)),
PARTITION p20221009 VALUES [(‘2022-10-09 00:00:00’), (‘2022-10-10 00:00:00’)),
PARTITION p20221010 VALUES [(‘2022-10-10 00:00:00’), (‘2022-10-11 00:00:00’)),
PARTITION p20221011 VALUES [(‘2022-10-11 00:00:00’), (‘2022-10-12 00:00:00’)),
PARTITION p20221012 VALUES [(‘2022-10-12 00:00:00’), (‘2022-10-13 00:00:00’)),
PARTITION p20221013 VALUES [(‘2022-10-13 00:00:00’), (‘2022-10-14 00:00:00’)),
PARTITION p20221014 VALUES [(‘2022-10-14 00:00:00’), (‘2022-10-15 00:00:00’)),
PARTITION p20221015 VALUES [(‘2022-10-15 00:00:00’), (‘2022-10-16 00:00:00’)),
PARTITION p20221016 VALUES [(‘2022-10-16 00:00:00’), (‘2022-10-17 00:00:00’)),
PARTITION p20221017 VALUES [(‘2022-10-17 00:00:00’), (‘2022-10-18 00:00:00’)),
PARTITION p20221018 VALUES [(‘2022-10-18 00:00:00’), (‘2022-10-19 00:00:00’)),
PARTITION p20221019 VALUES [(‘2022-10-19 00:00:00’), (‘2022-10-20 00:00:00’)),
PARTITION p20221020 VALUES [(‘2022-10-20 00:00:00’), (‘2022-10-21 00:00:00’)),
PARTITION p20221021 VALUES [(‘2022-10-21 00:00:00’), (‘2022-10-22 00:00:00’)),
PARTITION p20221022 VALUES [(‘2022-10-22 00:00:00’), (‘2022-10-23 00:00:00’)),
PARTITION p20221023 VALUES [(‘2022-10-23 00:00:00’), (‘2022-10-24 00:00:00’)),
PARTITION p20221024 VALUES [(‘2022-10-24 00:00:00’), (‘2022-10-25 00:00:00’)),
PARTITION p20221025 VALUES [(‘2022-10-25 00:00:00’), (‘2022-10-26 00:00:00’)),
PARTITION p20221026 VALUES [(‘2022-10-26 00:00:00’), (‘2022-10-27 00:00:00’)),
PARTITION p20221027 VALUES [(‘2022-10-27 00:00:00’), (‘2022-10-28 00:00:00’)),
PARTITION p20221028 VALUES [(‘2022-10-28 00:00:00’), (‘2022-10-29 00:00:00’)),
PARTITION p20221029 VALUES [(‘2022-10-29 00:00:00’), (‘2022-10-30 00:00:00’)),
PARTITION p20221030 VALUES [(‘2022-10-30 00:00:00’), (‘2022-10-31 00:00:00’)),
PARTITION p20221031 VALUES [(‘2022-10-31 00:00:00’), (‘2022-11-01 00:00:00’)),
PARTITION p20221101 VALUES [(‘2022-11-01 00:00:00’), (‘2022-11-02 00:00:00’)),
PARTITION p20221102 VALUES [(‘2022-11-02 00:00:00’), (‘2022-11-03 00:00:00’)),
PARTITION p20221103 VALUES [(‘2022-11-03 00:00:00’), (‘2022-11-04 00:00:00’)),
PARTITION p20221104 VALUES [(‘2022-11-04 00:00:00’), (‘2022-11-05 00:00:00’)),
PARTITION p20221105 VALUES [(‘2022-11-05 00:00:00’), (‘2022-11-06 00:00:00’)),
PARTITION p20221106 VALUES [(‘2022-11-06 00:00:00’), (‘2022-11-07 00:00:00’)),
PARTITION p20221107 VALUES [(‘2022-11-07 00:00:00’), (‘2022-11-08 00:00:00’)),
PARTITION p20221108 VALUES [(‘2022-11-08 00:00:00’), (‘2022-11-09 00:00:00’)),
PARTITION p20221109 VALUES [(‘2022-11-09 00:00:00’), (‘2022-11-10 00:00:00’)),
PARTITION p20221110 VALUES [(‘2022-11-10 00:00:00’), (‘2022-11-11 00:00:00’)),
PARTITION p20221111 VALUES [(‘2022-11-11 00:00:00’), (‘2022-11-12 00:00:00’)),
PARTITION p20221112 VALUES [(‘2022-11-12 00:00:00’), (‘2022-11-13 00:00:00’)),
PARTITION p20221113 VALUES [(‘2022-11-13 00:00:00’), (‘2022-11-14 00:00:00’)),
PARTITION p20221114 VALUES [(‘2022-11-14 00:00:00’), (‘2022-11-15 00:00:00’)),
PARTITION p20221115 VALUES [(‘2022-11-15 00:00:00’), (‘2022-11-16 00:00:00’)),
PARTITION p20221116 VALUES [(‘2022-11-16 00:00:00’), (‘2022-11-17 00:00:00’)),
PARTITION p20221117 VALUES [(‘2022-11-17 00:00:00’), (‘2022-11-18 00:00:00’)),
PARTITION p20221118 VALUES [(‘2022-11-18 00:00:00’), (‘2022-11-19 00:00:00’)),
PARTITION p20221119 VALUES [(‘2022-11-19 00:00:00’), (‘2022-11-20 00:00:00’)),
PARTITION p20221120 VALUES [(‘2022-11-20 00:00:00’), (‘2022-11-21 00:00:00’)),
PARTITION p20221121 VALUES [(‘2022-11-21 00:00:00’), (‘2022-11-22 00:00:00’)),
PARTITION p20221122 VALUES [(‘2022-11-22 00:00:00’), (‘2022-11-23 00:00:00’)),
PARTITION p20221123 VALUES [(‘2022-11-23 00:00:00’), (‘2022-11-24 00:00:00’)),
PARTITION p20221124 VALUES [(‘2022-11-24 00:00:00’), (‘2022-11-25 00:00:00’)),
PARTITION p20221125 VALUES [(‘2022-11-25 00:00:00’), (‘2022-11-26 00:00:00’)),
PARTITION p20221126 VALUES [(‘2022-11-26 00:00:00’), (‘2022-11-27 00:00:00’)),
PARTITION p20221127 VALUES [(‘2022-11-27 00:00:00’), (‘2022-11-28 00:00:00’)),
PARTITION p20221128 VALUES [(‘2022-11-28 00:00:00’), (‘2022-11-29 00:00:00’)),
PARTITION p20221129 VALUES [(‘2022-11-29 00:00:00’), (‘2022-11-30 00:00:00’)),
PARTITION p20221130 VALUES [(‘2022-11-30 00:00:00’), (‘2022-12-01 00:00:00’)))
DISTRIBUTED BY HASH(di_etl_date) BUCKETS 3
PROPERTIES (
“replication_num” = “3”,
“dynamic_partition.enable” = “true”,
“dynamic_partition.time_unit” = “DAY”,
“dynamic_partition.time_zone” = “Asia/Shanghai”,
“dynamic_partition.start” = “-1”,
“dynamic_partition.end” = “1”,
“dynamic_partition.prefix” = “p”,
“dynamic_partition.buckets” = “3”,
“dynamic_partition.replication_num” = “3”,
“in_memory” = “false”,
“storage_format” = “DEFAULT”
);

#9

请问这个有头绪吗，是因为是空表的原因吗，只有分区，没有数据

京ICP备2022026421号-1