Doris数据查询忽多忽少，同一个查询，一会数据量多，一会数据量少

[xinhai123456]

大佬们，请教个问题，Doris数据查询忽多忽少，同一个查询，一会数据量多，一会数据量少。

初步猜测：Doris Compaction 合并,导致副本之间数据短暂不一致。查询时来回切副本，结果就来回跳

这种问题怎么解决哈

[csun5285]

多副本之间一般不会出问题，Doris版本，建表语句，SQL 发送一下，我们来排查排查

[xinhai123456]

建表语句：

CREATE TABLE user_record (
active_date date NULL,
user_phone_number varchar(20) NULL,
platform_type varchar(256) NULL,
flag int NULL DEFAULT "0",
last_edit_time datetime NULL DEFAULT CURRENT_TIMESTAMP,
update_time datetime NULL DEFAULT CURRENT_TIMESTAMP,
create_time datetime NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=OLAP
UNIQUE KEY(active_date, user_phone_number, platform_type)
PARTITION BY RANGE(active_date)
(PARTITION p_202001 VALUES [('2020-01-01'), ('2020-02-01')),
PARTITION p_202002 VALUES [('2020-02-01'), ('2020-03-01')),
PARTITION p_202003 VALUES [('2020-03-01'), ('2020-04-01')),
PARTITION p_202004 VALUES [('2020-04-01'), ('2020-05-01')),
PARTITION p_202005 VALUES [('2020-05-01'), ('2020-06-01')),
PARTITION p_202006 VALUES [('2020-06-01'), ('2020-07-01')),
PARTITION p_202007 VALUES [('2020-07-01'), ('2020-08-01')),
PARTITION p_202008 VALUES [('2020-08-01'), ('2020-09-01')),
PARTITION p_202009 VALUES [('2020-09-01'), ('2020-10-01')),
PARTITION p_202010 VALUES [('2020-10-01'), ('2020-11-01')),
PARTITION p_202011 VALUES [('2020-11-01'), ('2020-12-01')),
PARTITION p_202012 VALUES [('2020-12-01'), ('2021-01-01')),
PARTITION p_202101 VALUES [('2021-01-01'), ('2021-02-01')),
PARTITION p_202102 VALUES [('2021-02-01'), ('2021-03-01')),
PARTITION p_202103 VALUES [('2021-03-01'), ('2021-04-01')),
PARTITION p_202104 VALUES [('2021-04-01'), ('2021-05-01')),
PARTITION p_202105 VALUES [('2021-05-01'), ('2021-06-01')),
PARTITION p_202106 VALUES [('2021-06-01'), ('2021-07-01')),
PARTITION p_202107 VALUES [('2021-07-01'), ('2021-08-01')),
PARTITION p_202108 VALUES [('2021-08-01'), ('2021-09-01')),
PARTITION p_202109 VALUES [('2021-09-01'), ('2021-10-01')),
PARTITION p_202110 VALUES [('2021-10-01'), ('2021-11-01')),
PARTITION p_202111 VALUES [('2021-11-01'), ('2021-12-01')),
PARTITION p_202112 VALUES [('2021-12-01'), ('2022-01-01')),
PARTITION p_202201 VALUES [('2022-01-01'), ('2022-02-01')),
PARTITION p_202202 VALUES [('2022-02-01'), ('2022-03-01')),
PARTITION p_202203 VALUES [('2022-03-01'), ('2022-04-01')),
PARTITION p_202204 VALUES [('2022-04-01'), ('2022-05-01')),
PARTITION p_202205 VALUES [('2022-05-01'), ('2022-06-01')),
PARTITION p_202206 VALUES [('2022-06-01'), ('2022-07-01')),
PARTITION p_202207 VALUES [('2022-07-01'), ('2022-08-01')),
PARTITION p_202208 VALUES [('2022-08-01'), ('2022-09-01')),
PARTITION p_202209 VALUES [('2022-09-01'), ('2022-10-01')),
PARTITION p_202210 VALUES [('2022-10-01'), ('2022-11-01')),
PARTITION p_202211 VALUES [('2022-11-01'), ('2022-12-01')),
PARTITION p_202212 VALUES [('2022-12-01'), ('2023-01-01')),
PARTITION p_202301 VALUES [('2023-01-01'), ('2023-02-01')),
PARTITION p_202302 VALUES [('2023-02-01'), ('2023-03-01')),
PARTITION p_202303 VALUES [('2023-03-01'), ('2023-04-01')),
PARTITION p_202304 VALUES [('2023-04-01'), ('2023-05-01')),
PARTITION p_202305 VALUES [('2023-05-01'), ('2023-06-01')),
PARTITION p_202306 VALUES [('2023-06-01'), ('2023-07-01')),
PARTITION p_202307 VALUES [('2023-07-01'), ('2023-08-01')),
PARTITION p_202308 VALUES [('2023-08-01'), ('2023-09-01')),
PARTITION p_202309 VALUES [('2023-09-01'), ('2023-10-01')),
PARTITION p_202310 VALUES [('2023-10-01'), ('2023-11-01')),
PARTITION p_202311 VALUES [('2023-11-01'), ('2023-12-01')),
PARTITION p_202312 VALUES [('2023-12-01'), ('2024-01-01')),
PARTITION p_202401 VALUES [('2024-01-01'), ('2024-02-01')),
PARTITION p_202402 VALUES [('2024-02-01'), ('2024-03-01')),
PARTITION p_202403 VALUES [('2024-03-01'), ('2024-04-01')),
PARTITION p_202404 VALUES [('2024-04-01'), ('2024-05-01')),
PARTITION p_202405 VALUES [('2024-05-01'), ('2024-06-01')),
PARTITION p_202406 VALUES [('2024-06-01'), ('2024-07-01')),
PARTITION p_202407 VALUES [('2024-07-01'), ('2024-08-01')),
PARTITION p_202408 VALUES [('2024-08-01'), ('2024-09-01')),
PARTITION p_202409 VALUES [('2024-09-01'), ('2024-10-01')),
PARTITION p_202410 VALUES [('2024-10-01'), ('2024-11-01')),
PARTITION p_202411 VALUES [('2024-11-01'), ('2024-12-01')),
PARTITION p_202412 VALUES [('2024-12-01'), ('2025-01-01')),
PARTITION p_202501 VALUES [('2025-01-01'), ('2025-02-01')),
PARTITION p_202502 VALUES [('2025-02-01'), ('2025-03-01')),
PARTITION p_202503 VALUES [('2025-03-01'), ('2025-04-01')),
PARTITION p_202504 VALUES [('2025-04-01'), ('2025-05-01')),
PARTITION p_202505 VALUES [('2025-05-01'), ('2025-06-01')),
PARTITION p_202506 VALUES [('2025-06-01'), ('2025-07-01')),
PARTITION p_202507 VALUES [('2025-07-01'), ('2025-08-01')),
PARTITION p_202508 VALUES [('2025-08-01'), ('2025-09-01')),
PARTITION p_202509 VALUES [('2025-09-01'), ('2025-10-01')),
PARTITION p_202510 VALUES [('2025-10-01'), ('2025-11-01')),
PARTITION p_202511 VALUES [('2025-11-01'), ('2025-12-01')),
PARTITION p_202512 VALUES [('2025-12-01'), ('2026-01-01')),
PARTITION p_202601 VALUES [('2026-01-01'), ('2026-02-01')),
PARTITION p_202602 VALUES [('2026-02-01'), ('2026-03-01')),
PARTITION p_202603 VALUES [('2026-03-01'), ('2026-04-01')),
PARTITION p_202604 VALUES [('2026-04-01'), ('2026-05-01')),
PARTITION p_202605 VALUES [('2026-05-01'), ('2026-06-01')),
PARTITION p_202606 VALUES [('2026-06-01'), ('2026-07-01')),
PARTITION p_202607 VALUES [('2026-07-01'), ('2026-08-01')),
PARTITION p_202608 VALUES [('2026-08-01'), ('2026-09-01')),
PARTITION p_202609 VALUES [('2026-09-01'), ('2026-10-01')),
PARTITION p_202610 VALUES [('2026-10-01'), ('2026-11-01')),
PARTITION p_202611 VALUES [('2026-11-01'), ('2026-12-01')),
PARTITION p_202612 VALUES [('2026-12-01'), ('2027-01-01')),
PARTITION p_202701 VALUES [('2027-01-01'), ('2027-02-01')),
PARTITION p_202702 VALUES [('2027-02-01'), ('2027-03-01')),
PARTITION p_202703 VALUES [('2027-03-01'), ('2027-04-01')),
PARTITION p_202704 VALUES [('2027-04-01'), ('2027-05-01')),
PARTITION p_202705 VALUES [('2027-05-01'), ('2027-06-01')),
PARTITION p_202706 VALUES [('2027-06-01'), ('2027-07-01')),
PARTITION p_202707 VALUES [('2027-07-01'), ('2027-08-01')),
PARTITION p_202708 VALUES [('2027-08-01'), ('2027-09-01')),
PARTITION p_202709 VALUES [('2027-09-01'), ('2027-10-01')),
PARTITION p_202710 VALUES [('2027-10-01'), ('2027-11-01')),
PARTITION p_202711 VALUES [('2027-11-01'), ('2027-12-01')),
PARTITION p_202712 VALUES [('2027-12-01'), ('2028-01-01')),
PARTITION p_202801 VALUES [('2028-01-01'), ('2028-02-01')),
PARTITION p_202802 VALUES [('2028-02-01'), ('2028-03-01')),
PARTITION p_202803 VALUES [('2028-03-01'), ('2028-04-01')),
PARTITION p_202804 VALUES [('2028-04-01'), ('2028-05-01')),
PARTITION p_202805 VALUES [('2028-05-01'), ('2028-06-01')),
PARTITION p_202806 VALUES [('2028-06-01'), ('2028-07-01')),
PARTITION p_202807 VALUES [('2028-07-01'), ('2028-08-01')),
PARTITION p_202808 VALUES [('2028-08-01'), ('2028-09-01')),
PARTITION p_202809 VALUES [('2028-09-01'), ('2028-10-01')),
PARTITION p_202810 VALUES [('2028-10-01'), ('2028-11-01')),
PARTITION p_202811 VALUES [('2028-11-01'), ('2028-12-01')),
PARTITION p_202812 VALUES [('2028-12-01'), ('2029-01-01')),
PARTITION p_202901 VALUES [('2029-01-01'), ('2029-02-01')),
PARTITION p_202902 VALUES [('2029-02-01'), ('2029-03-01')),
PARTITION p_202903 VALUES [('2029-03-01'), ('2029-04-01')),
PARTITION p_202904 VALUES [('2029-04-01'), ('2029-05-01')),
PARTITION p_202905 VALUES [('2029-05-01'), ('2029-06-01')),
PARTITION p_202906 VALUES [('2029-06-01'), ('2029-07-01')),
PARTITION p_202907 VALUES [('2029-07-01'), ('2029-08-01')),
PARTITION p_202908 VALUES [('2029-08-01'), ('2029-09-01')),
PARTITION p_202909 VALUES [('2029-09-01'), ('2029-10-01')),
PARTITION p_202910 VALUES [('2029-10-01'), ('2029-11-01')),
PARTITION p_202911 VALUES [('2029-11-01'), ('2029-12-01')),
PARTITION p_202912 VALUES [('2029-12-01'), ('2030-01-01')),
PARTITION p_203001 VALUES [('2030-01-01'), ('2030-02-01')),
PARTITION p_203002 VALUES [('2030-02-01'), ('2030-03-01')),
PARTITION p_203003 VALUES [('2030-03-01'), ('2030-04-01')),
PARTITION p_203004 VALUES [('2030-04-01'), ('2030-05-01')),
PARTITION p_203005 VALUES [('2030-05-01'), ('2030-06-01')),
PARTITION p_203006 VALUES [('2030-06-01'), ('2030-07-01')),
PARTITION p_203007 VALUES [('2030-07-01'), ('2030-08-01')),
PARTITION p_203008 VALUES [('2030-08-01'), ('2030-09-01')),
PARTITION p_203009 VALUES [('2030-09-01'), ('2030-10-01')),
PARTITION p_203010 VALUES [('2030-10-01'), ('2030-11-01')),
PARTITION p_203011 VALUES [('2030-11-01'), ('2030-12-01')),
PARTITION p_203012 VALUES [('2030-12-01'), ('2031-01-01')),
PARTITION p_203101 VALUES [('2031-01-01'), ('2031-02-01')),
PARTITION p_203102 VALUES [('2031-02-01'), ('2031-03-01')),
PARTITION p_203103 VALUES [('2031-03-01'), ('2031-04-01')),
PARTITION p_203104 VALUES [('2031-04-01'), ('2031-05-01')),
PARTITION p_203105 VALUES [('2031-05-01'), ('2031-06-01')),
PARTITION p_203106 VALUES [('2031-06-01'), ('2031-07-01')),
PARTITION p_203107 VALUES [('2031-07-01'), ('2031-08-01')),
PARTITION p_203108 VALUES [('2031-08-01'), ('2031-09-01')),
PARTITION p_203109 VALUES [('2031-09-01'), ('2031-10-01')),
PARTITION p_203110 VALUES [('2031-10-01'), ('2031-11-01')),
PARTITION p_203111 VALUES [('2031-11-01'), ('2031-12-01')),
PARTITION p_203112 VALUES [('2031-12-01'), ('2032-01-01')),
PARTITION p_203201 VALUES [('2032-01-01'), ('2032-02-01')),
PARTITION p_203202 VALUES [('2032-02-01'), ('2032-03-01')),
PARTITION p_203203 VALUES [('2032-03-01'), ('2032-04-01')),
PARTITION p_203204 VALUES [('2032-04-01'), ('2032-05-01')),
PARTITION p_203205 VALUES [('2032-05-01'), ('2032-06-01')),
PARTITION p_203206 VALUES [('2032-06-01'), ('2032-07-01')),
PARTITION p_203207 VALUES [('2032-07-01'), ('2032-08-01')),
PARTITION p_203208 VALUES [('2032-08-01'), ('2032-09-01')),
PARTITION p_203209 VALUES [('2032-09-01'), ('2032-10-01')),
PARTITION p_203210 VALUES [('2032-10-01'), ('2032-11-01')),
PARTITION p_203211 VALUES [('2032-11-01'), ('2032-12-01')),
PARTITION p_203212 VALUES [('2032-12-01'), ('2033-01-01')),
PARTITION p_203301 VALUES [('2033-01-01'), ('2033-02-01')),
PARTITION p_203302 VALUES [('2033-02-01'), ('2033-03-01')),
PARTITION p_203303 VALUES [('2033-03-01'), ('2033-04-01')),
PARTITION p_203304 VALUES [('2033-04-01'), ('2033-05-01')),
PARTITION p_203305 VALUES [('2033-05-01'), ('2033-06-01')),
PARTITION p_203306 VALUES [('2033-06-01'), ('2033-07-01')),
PARTITION p_203307 VALUES [('2033-07-01'), ('2033-08-01')),
PARTITION p_203308 VALUES [('2033-08-01'), ('2033-09-01')),
PARTITION p_203309 VALUES [('2033-09-01'), ('2033-10-01')),
PARTITION p_203310 VALUES [('2033-10-01'), ('2033-11-01')),
PARTITION p_203311 VALUES [('2033-11-01'), ('2033-12-01')),
PARTITION p_203312 VALUES [('2033-12-01'), ('2034-01-01')),
PARTITION p_203401 VALUES [('2034-01-01'), ('2034-02-01')),
PARTITION p_203402 VALUES [('2034-02-01'), ('2034-03-01')),
PARTITION p_203403 VALUES [('2034-03-01'), ('2034-04-01')),
PARTITION p_203404 VALUES [('2034-04-01'), ('2034-05-01')),
PARTITION p_203405 VALUES [('2034-05-01'), ('2034-06-01')),
PARTITION p_203406 VALUES [('2034-06-01'), ('2034-07-01')),
PARTITION p_203407 VALUES [('2034-07-01'), ('2034-08-01')),
PARTITION p_203408 VALUES [('2034-08-01'), ('2034-09-01')),
PARTITION p_203409 VALUES [('2034-09-01'), ('2034-10-01')),
PARTITION p_203410 VALUES [('2034-10-01'), ('2034-11-01')),
PARTITION p_203411 VALUES [('2034-11-01'), ('2034-12-01')),
PARTITION p_203412 VALUES [('2034-12-01'), ('2035-01-01')),
PARTITION p_203501 VALUES [('2035-01-01'), ('2035-02-01')),
PARTITION p_203502 VALUES [('2035-02-01'), ('2035-03-01')),
PARTITION p_203503 VALUES [('2035-03-01'), ('2035-04-01')),
PARTITION p_203504 VALUES [('2035-04-01'), ('2035-05-01')),
PARTITION p_203505 VALUES [('2035-05-01'), ('2035-06-01')),
PARTITION p_203506 VALUES [('2035-06-01'), ('2035-07-01')),
PARTITION p_203507 VALUES [('2035-07-01'), ('2035-08-01')),
PARTITION p_203508 VALUES [('2035-08-01'), ('2035-09-01')),
PARTITION p_203509 VALUES [('2035-09-01'), ('2035-10-01')),
PARTITION p_203510 VALUES [('2035-10-01'), ('2035-11-01')),
PARTITION p_203511 VALUES [('2035-11-01'), ('2035-12-01')),
PARTITION p_203512 VALUES [('2035-12-01'), ('2036-01-01')),
PARTITION p_203601 VALUES [('2036-01-01'), ('2036-02-01')),
PARTITION p_203602 VALUES [('2036-02-01'), ('2036-03-01')),
PARTITION p_203603 VALUES [('2036-03-01'), ('2036-04-01')),
PARTITION p_203604 VALUES [('2036-04-01'), ('2036-05-01')),
PARTITION p_203605 VALUES [('2036-05-01'), ('2036-06-01')),
PARTITION p_203606 VALUES [('2036-06-01'), ('2036-07-01')),
PARTITION p_203607 VALUES [('2036-07-01'), ('2036-08-01')),
PARTITION p_203608 VALUES [('2036-08-01'), ('2036-09-01')),
PARTITION p_203609 VALUES [('2036-09-01'), ('2036-10-01')),
PARTITION p_203610 VALUES [('2036-10-01'), ('2036-11-01')),
PARTITION p_203611 VALUES [('2036-11-01'), ('2036-12-01')),
PARTITION p_203612 VALUES [('2036-12-01'), ('2037-01-01')),
PARTITION p_203701 VALUES [('2037-01-01'), ('2037-02-01')),
PARTITION p_203702 VALUES [('2037-02-01'), ('2037-03-01')),
PARTITION p_203703 VALUES [('2037-03-01'), ('2037-04-01')),
PARTITION p_203704 VALUES [('2037-04-01'), ('2037-05-01')),
PARTITION p_203705 VALUES [('2037-05-01'), ('2037-06-01')),
PARTITION p_203706 VALUES [('2037-06-01'), ('2037-07-01')),
PARTITION p_203707 VALUES [('2037-07-01'), ('2037-08-01')),
PARTITION p_203708 VALUES [('2037-08-01'), ('2037-09-01')),
PARTITION p_203709 VALUES [('2037-09-01'), ('2037-10-01')),
PARTITION p_203710 VALUES [('2037-10-01'), ('2037-11-01')),
PARTITION p_203711 VALUES [('2037-11-01'), ('2037-12-01')),
PARTITION p_203712 VALUES [('2037-12-01'), ('2038-01-01')),
PARTITION p_203801 VALUES [('2038-01-01'), ('2038-02-01')),
PARTITION p_203802 VALUES [('2038-02-01'), ('2038-03-01')),
PARTITION p_203803 VALUES [('2038-03-01'), ('2038-04-01')),
PARTITION p_203804 VALUES [('2038-04-01'), ('2038-05-01')),
PARTITION p_203805 VALUES [('2038-05-01'), ('2038-06-01')),
PARTITION p_203806 VALUES [('2038-06-01'), ('2038-07-01')),
PARTITION p_203807 VALUES [('2038-07-01'), ('2038-08-01')),
PARTITION p_203808 VALUES [('2038-08-01'), ('2038-09-01')),
PARTITION p_203809 VALUES [('2038-09-01'), ('2038-10-01')),
PARTITION p_203810 VALUES [('2038-10-01'), ('2038-11-01')),
PARTITION p_203811 VALUES [('2038-11-01'), ('2038-12-01')),
PARTITION p_203812 VALUES [('2038-12-01'), ('2039-01-01')),
PARTITION p_203901 VALUES [('2039-01-01'), ('2039-02-01')),
PARTITION p_203902 VALUES [('2039-02-01'), ('2039-03-01')),
PARTITION p_203903 VALUES [('2039-03-01'), ('2039-04-01')),
PARTITION p_203904 VALUES [('2039-04-01'), ('2039-05-01')),
PARTITION p_203905 VALUES [('2039-05-01'), ('2039-06-01')),
PARTITION p_203906 VALUES [('2039-06-01'), ('2039-07-01')),
PARTITION p_203907 VALUES [('2039-07-01'), ('2039-08-01')),
PARTITION p_203908 VALUES [('2039-08-01'), ('2039-09-01')),
PARTITION p_203909 VALUES [('2039-09-01'), ('2039-10-01')),
PARTITION p_203910 VALUES [('2039-10-01'), ('2039-11-01')),
PARTITION p_203911 VALUES [('2039-11-01'), ('2039-12-01')),
PARTITION p_203912 VALUES [('2039-12-01'), ('2040-01-01')))
DISTRIBUTED BY HASH(user_phone_number) BUCKETS 1
PROPERTIES (
"replication_allocation" = "tag.location.default: 3",
"min_load_replica_num" = "-1",
"is_being_synced" = "false",
"storage_medium" = "hdd",
"storage_format" = "V2",
"inverted_index_storage_format" = "V1",
"enable_unique_key_merge_on_write" = "true",
"light_schema_change" = "true",
"disable_auto_compaction" = "false",
"binlog.enable" = "false",
"binlog.ttl_seconds" = "86400",
"binlog.max_bytes" = "9223372036854775807",
"binlog.max_history_nums" = "9223372036854775807",
"enable_single_replica_compaction" = "false",
"group_commit_interval_ms" = "10000",
"group_commit_data_bytes" = "134217728",
"enable_mow_light_delete" = "false"
);

统计SQL:
select active_date,platform_type, count(user_phone_number)
from user_record
where active_date >= '2026-04-01'
group by active_date,platform_type;

说明：查询时，存在4月份数据在写入。然后统计到的4月份某一天数据一会多一会少，数据真实存在，看着像是存在请求打到某个BE合并导致的查不出来