【详述】starrocks 2.5.7 出现异常： transmit chunk rpc failed:
【背景】 表查询
【业务影响】
【StarRocks版本】2.5.7
【集群规模】3fe（1 follower+2observer）15 be
【机器信息】fe cpu(arm)8核 32G ,be cpu(arm)16核 32G
【联系方式】wangmonrg@gmail.com
【附件】
ddl
CREATE TABLE entity_106_label_summary (
label_id int(11) NOT NULL COMMENT “标签标识”,
update_time datetime NOT NULL COMMENT “更新时间”,
label_value varchar(128) NULL COMMENT “标签值”,
conf_score decimal64(10, 2) NULL COMMENT “可信度分”,
label_type int(11) NULL COMMENT “标签类型”,
act_score decimal64(10, 2) NULL COMMENT “ID 活跃度”,
source_dt datetime NULL COMMENT “数据来源发分区”,
seq_id_bitmap bitmap BITMAP_UNION NOT NULL COMMENT “SeqID集合”
) ENGINE=OLAP
AGGREGATE KEY(label_id, update_time, label_value, conf_score, label_type, act_score, source_dt)
COMMENT “标签汇总表”
PARTITION BY RANGE(update_time)
(PARTITION p20230516 VALUES [(“0000-01-01 00:00:00”), (“2023-05-17 00:00:00”))
PARTITION p20230708 VALUES [(“2023-07-08 00:00:00”), (“2023-07-09 00:00:00”)))
DISTRIBUTED BY HASH(label_id, label_value, label_type) BUCKETS 3
PROPERTIES (
“replication_num” = “3”,
“dynamic_partition.enable” = “true”,
“dynamic_partition.time_unit” = “DAY”,
“dynamic_partition.time_zone” = “Asia/Shanghai”,
“dynamic_partition.start” = “-2147483648”,
“dynamic_partition.end” = “2”,
“dynamic_partition.prefix” = “p”,
“dynamic_partition.buckets” = “3”,
“dynamic_partition.history_partition_num” = “0”,
“in_memory” = “false”,
“storage_format” = “DEFAULT”,
“enable_persistent_index” = “false”,
“compression” = “LZ4”
);
- 查询报错：
transmit chunk rpc failed: error 1064 (HY00)
expalin sql:
