【详述】同一个 SQL，连续多次查询，出现数据查询不到结果的情况，实际上是有数据的，也没有删数据重新写入的动作。
【业务影响】暂无影响
【是否存算分离】寸算一体
【StarRocks版本】3.1.5
【集群规模】4fe+ 18be（fe与be混部）
【机器信息】
【联系方式】 请社区联系或者邮箱 392348681@qq.com，谢谢
【附件】
ENGINE=OLAP
PRIMARY KEY(`MANDT`, `RUECK`, `RMZHL`)
DISTRIBUTED BY HASH(`RUECK`)
PROPERTIES (
"replication_num" = "3",
"in_memory" = "false",
"enable_persistent_index" = "true",
"replicated_storage" = "false",
"compression" = "LZ4"
);
查不出来和查出来的explain costs + sql结果发下
mysql> select MANDT, RUECK, RMZHL from SAP.AFRU t where RUECK = 3714918;
Empty set (0.01 sec)
mysql> explain costs select MANDT, RUECK, RMZHL from SAP.AFRU t where RUECK = 3714918;
+------------------------------------------------------------------------------+
| Explain String |
+------------------------------------------------------------------------------+
| PLAN FRAGMENT 0(F00) |
| Output Exprs:1: MANDT | 2: RUECK | 3: RMZHL |
| Input Partition: RANDOM |
| RESULT SINK |
| |
| 0:OlapScanNode |
| table: AFRU, rollup: AFRU |
| preAggregation: on |
| Predicates: [2: RUECK, INT, false] = 3714918 |
| partitionsRatio=1/1, tabletsRatio=1/27 |
| tabletList=5450415 |
| actualRows=223581, avgRowSize=11.0 |
| cardinality: 1 |
| column statistics: |
| * MANDT-->[-Infinity, Infinity, 0.0, 3.0, 1.0] ESTIMATE |
| * RUECK-->[3714918.0, 3714918.0, 0.0, 4.0, 1.3735348368779567] ESTIMATE |
| * RMZHL-->[1.0, 19151.0, 0.0, 4.0, 1.3735348368779567] ESTIMATE |
+------------------------------------------------------------------------------+
17 rows in set (0.01 sec)
mysql> select MANDT, RUECK, RMZHL from SAP.AFRU t where RUECK = 3714918;
+-------+---------+-------+
| MANDT | RUECK | RMZHL |
+-------+---------+-------+
| 800 | 3714918 | 1 |
+-------+---------+-------+
1 row in set (0.01 sec)
mysql> explain costs select MANDT, RUECK, RMZHL from SAP.AFRU t where RUECK = 3714918;
+-----------------------------------------------------------------------------+
| Explain String |
+-----------------------------------------------------------------------------+
| PLAN FRAGMENT 0(F00) |
| Output Exprs:1: MANDT | 2: RUECK | 3: RMZHL |
| Input Partition: RANDOM |
| RESULT SINK |
| |
| 0:OlapScanNode |
| table: AFRU, rollup: AFRU |
| preAggregation: on |
| Predicates: [2: RUECK, INT, false] = 3714918 |
| partitionsRatio=1/1, tabletsRatio=1/27 |
| tabletList=5450415 |
| actualRows=92, avgRowSize=11.0 |
| cardinality: 1 |
| column statistics: |
| * MANDT-->[-Infinity, Infinity, 0.0, 3.0, 1.0] ESTIMATE |
| * RUECK-->[3714918.0, 3714918.0, 0.0, 4.0, 1.373534155314277] ESTIMATE |
| * RMZHL-->[1.0, 19151.0, 0.0, 4.0, 1.373534155314277] ESTIMATE |
+-----------------------------------------------------------------------------+
17 rows in set (0.00 sec)
mysql>