SELECTDB WEBUI每次查询hive catalog表结果不一致

Viewed 33

manager版本:v24.1.4
doris版本:doris-3.0.3-rc04-62a58bff4c
hive catalog:

CREATE CATALOG `hive` PROPERTIES (
  "uri" = "thrift://xxx:9083,thrift://xxx:9083",
  "type" = "hms",
  "metadata_refresh_interval_sec" = "3600",
  "ipc.client.fallback-to-simple-auth-allowed" = "true",
  "hive.metastore.uris" = "thrift://xxx:9083,thrift://xxx:9083",
  "dfs.nameservices" = "xxxxx",
  "dfs.namenode.rpc-address.hacluster.4" = "xxx:8020",
  "dfs.namenode.rpc-address.hacluster.3" = "xxx:8020",
  "dfs.ha.namenodes.hacluster" = "3,4",
  "dfs.client.failover.proxy.provider.hacluster" = "org.apache.hadoop.hdfs.server.namenode.ha.ConfiguredFailoverProxyProvider"
);

hive表结构

CREATE TABLE `dwb_r_apply`(
    `apply_id` int,
    `apply_uuid` bigint,
    `apply_user_uuid` bigint,
    `apply_ask_loan_uuid` bigint,
    `apply_source` bigint,
    `apply_status` bigint,
    `apply_finish_at` string,
    `apply_is_deleted` char(1),
    `apply_created_at` string,
    `apply_updated_at` string
  ) PARTITIONED BY (`dt` string) ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.orc.OrcSerde'
WITH
  SERDEPROPERTIES ('serialization.format' = '1') STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat' LOCATION 'hdfs://hacluster/user/hive/warehouse/dwb.db/dwb_r_apply' TBLPROPERTIES (
    'orc.compress' = 'SNAPPY',
    'transient_lastDdlTime' = '1726148351'
  )

问题描述:select count(*)每次查询结果不一致,通过mysql client连接doris查询结果正常,如图所示,图1图2是web ui查询两次的结果,图3是client连接doris fe的查询结果

web ui查询结果1
web ui查询结果2
client查询结果

1 Answers

麻烦提供下查询的explain,或者加我微信(hhj_0530)私聊