starrocks版本:2.0.1
表类型:主键模型
问题描述:查询主键模型表抛出异常:
fail to prepare tablet reader 672250.1127264479.9543638b6955e4f2-9dc65cc66af95b81: Not found: rowset version 22947 not found
具体的be日志:
建表语句:
CREATE TABLE rt_analysis.dws_user_trade_asset_detail
(
fcreate_date DATE NOT NULL COMMENT ‘创建日期’,
forder_id VARCHAR(25) NOT NULL COMMENT ‘订单ID;’,
forder_id_hash INT NOT NULL COMMENT ‘订单ID;’,
fasset_id VARCHAR(25) NOT NULL COMMENT ‘资产ID;’,
fuid INT NOT NULL COMMENT ‘用户uid;’,
fcreate_time DATETIME NOT NULL COMMENT ‘创建时间’,
fmodify_time DATETIME NOT NULL COMMENT ‘修改时间’
)
PRIMARY KEY(fcreate_date,forder_id,forder_id_hash)
PARTITION BY RANGE(fcreate_date)(
START ("2021-01-01") END ("2022-03-01") EVERY (INTERVAL 1 day)
)
DISTRIBUTED BY HASH(forder_id_hash) BUCKETS 200
PROPERTIES(
"replication_num" = "1",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.end" = "3",
"dynamic_partition.prefix" = "p",
"dynamic_partition.buckets" = "200");