同一张表，同一条sql，会出现查出来数据不一致的情况，不知道为什么，3个fe，6个be，sr版本是3.0.8。
SELECT
COUNT(platform_order_id) AS count_platform_order_id
FROM
xingmeng_order_bak
WHERE
tenant_id IN (‘1815338921386012672’) and
pay_success_time BETWEEN ‘2024-07-01 00:00:00’
AND ‘2024-09-23 23:59:59’
执行计划
MySQL [data_cube]> EXPLAIN SELECT COUNT(platform_order_id) FROM xingmeng_order_bak
-> WHERE
-> tenant_id IN (‘1815338921386012672’)
-> AND pay_success_time BETWEEN ‘2024-07-01 00:00:00’
-> AND ‘2024-09-23 23:59:59’;
±---------------------------------------------------------------------------------------------------+
| Explain String |
±---------------------------------------------------------------------------------------------------+
| PLAN FRAGMENT 0 |
| OUTPUT EXPRS:85: count |
| PARTITION: UNPARTITIONED |
| |
| RESULT SINK |
| |
| 4:AGGREGATE (merge finalize) |
| | output: count(85: count) |
| | group by: |
| | |
| 3:EXCHANGE |
| |
| PLAN FRAGMENT 1 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 03 |
| UNPARTITIONED |
| |
| 2:AGGREGATE (update serialize) |
| | output: count(2: platform_order_id) |
| | group by: |
| | |
| 1:Project |
| | <slot 2> : 2: platform_order_id |
| | |
| 0:OlapScanNode |
| TABLE: xingmeng_order_bak |
| PREAGGREGATION: ON |
| PREDICATES: 50: tenant_id = 1815338921386012672, 1: pay_success_time <= ‘2024-09-23 23:59:59’ |
| partitions=3/14 |
| rollup: xingmeng_order_bak |
| tabletRatio=3/3 |
| tabletList=11241337,11241393,11281828 |
| cardinality=5480 |
| avgRowSize=24.0 |
| numNodes=0 |
±---------------------------------------------------------------------------------------------------+
38 rows in set (0.006 sec)
