【详述】
表CREATE TABLE IF NOT EXISTS ex_rank (
id bigint(20) NOT NULL COMMENT “数据唯一标识”,
time_type INT NOT NULL COMMENT “时间类型”,
site_no varchar(255) NOT NULL COMMENT “站号”,
acc_minute BIGINT NOT NULL COMMENT “累积时间分钟数”,
element varchar(255) NOT NULL COMMENT “要素 AccRain,TMax, TMin, WindSpeedTop, WindSpeedMax”,
rank INT NOT NULL COMMENT “排名”,
orgin_val DECIMAL(10, 2) NOT NULL COMMENT “要素原始值”,
val DECIMAL(10, 2) NOT NULL COMMENT “要素值”,
start_time DATETIME NOT NULL COMMENT “开始时间”,
end_time DATETIME NOT NULL COMMENT “结束时间”,
ex_time DATETIME NOT NULL COMMENT “极值时间”,
delete_flag varchar(255) COMMENT “软删除标记”,
create_time DATETIME NOT NULL COMMENT “创建时间”,
create_user varchar(255) NULL COMMENT “创建时间”,
update_time DATETIME NOT NULL COMMENT “更新时间”,
update_user varchar(255) NULL COMMENT “更新用户”,
remark varchar(255) NULL COMMENT “备注”,
ext_json varchar(255) NULL COMMENT “扩展Json”,
status SMALLINT NOT NULL COMMENT “状态”,
source varchar(255) NULL COMMENT “数据来源”
)
PRIMARY KEY(id,time_type)
PARTITION BY (time_type)
DISTRIBUTED BY HASH(time_type) BUCKETS 8
PROPERTIES (
“replication_num” = “1”,
“in_memory” = “false”,
“enable_persistent_index” = “false”,
“replicated_storage” = “true”,
“compression” = “LZ4”
);
使用查询语句：SELECT * from ex_rank er where time_type = 0查询为空
使用SELECT * from ex_rank er 时可以看到为time_type = 0的数据
使用SELECT * from ex_rank PARTITIONS(p0) where time_type = 0 查询有数据
使用SELECT * from ex_rank er where time_type = 6 查询有数据
【背景】做过哪些操作？
【业务影响】
【是否存算分离】否
【StarRocks版本】3.2.3-a40e2f8
【集群规模】docker部署 allin1 镜像：starrocks/allin1-ubuntu:3.2.3