A paimon table created and written by flinksql. Add the table as an external table in starRocks.
Just count the result according to time_date field. The sum of count(time_date <= 'v') and count(time_date > 'v') is not equal to the total count value. MySQL [(none)]> select count(1) from paimon_catalog.ubs_1.dwd_ubs_events; +----------+ | count(1) | +----------+ | 684791 | +----------+ MySQL [(none)]> select count(1) from paimon_catalog.ubs_1.dwd_ubs_events where time_date < '2025-07-23 16:00:00'; +----------+ | count(1) | +----------+ | 50 | +----------+ MySQL [(none)]> select count(1) from paimon_catalog.ubs_1.dwd_ubs_events where time_date >= '2025-07-23 16:00:00'; +----------+ | count(1) | +----------+ | 70429 | +----------+ Any insight on this ? Thanks, Lei