我的表结构是这样的:
create table imp_energy_item_day
(
pk_id varchar(32) not null,
collect_time varchar(16),
create_ts datetime,
pk_entity_project bigint,
entity_project_name varchar(128),
entity_project_code varchar(128),
pk_construct bigint,
construct_facility_no varchar(128),
construct_facility_name varchar(128),
item_id bigint null comment '回路主键',
item_code varchar(32),
item_name varchar(512) comment '回路名称',
parent_item_id bigint,
pk_metering bigint,
single_id varchar(128),
collect_month varchar(8),
day varchar(8),
energy_target_code varchar(16),
val double,
calc_val double,
loss_val double,
flag varchar(8),
energy_type varchar(16)
)unique key(pk_id, collect_time)
comment '支路用能-日'
auto partition by list(collect_time)()
distributed by hash(pk_id) buckets auto
properties (
"replication_allocation" = "tag.location.default: 3",
"enable_unique_key_merge_on_write" = "true"
);
表内无数据,但是执行查询直接会超时,未能找到原因,请帮忙协助排查
SELECT *
FROM IMP_ENERGY_ITEM_DAY
WHERE ITEM_ID IN
(1595012731474280448, 1595013220588847104, 1595013220634984448, 1595013220672733184, 1595013220718870528,
1595013220760813568, 1595013220798562304, 1595013220832116736, 1595013220869865472, 1595013220911808512,
1595013220945362944, 1595013220983111680, 1595013221025054720, 1595013221066997760, 1595013221104746496,
1595013221146689536, 1595013221188632576, 1595013221222187008, 1595013221255741440, 1595013221289295872)
AND ENERGY_TARGET_CODE = 'E_electricity'
AND COLLECT_TIME IN ('2025-02-09','2025-02-10','2025-02-11')