2.1.8查询数据超时

Viewed 73

我的表结构是这样的:

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')

1 Answers

本地已经复现,正在跟进中