Re: Strange result when querying paimon from starrocks.

[Jingsong Li]

Hi Lei,

Can you try to use Flink SQL or Spark SQL?

Best,
Jingsong

On Wed, Jul 23, 2025 at 4:32 PM Lei Wang <leiwang...@gmail.com> wrote:
>
> 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
>