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

Reply via email to