Hi Jingsong, When using flinkSQL, the result is correct
I am just curious why the result is so strange when using starrocks and want to solve it. We have situations that need to use starrocks to query paimon table written by flink. Thanks, Lei On Wed, Jul 23, 2025 at 4:36 PM Jingsong Li <jingsongl...@gmail.com> wrote: > 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 > > >
