This problem is in PR: https://github.com/StarRocks/starrocks/pull/60473
And you can also use set time_zone='UTC' to workaround. Best, Jingsong On Wed, Jul 23, 2025 at 5:47 PM Jingsong Li <jingsongl...@gmail.com> wrote: > > Let's check it with StarRocks experts. > > On Wed, Jul 23, 2025 at 4:48 PM Lei Wang <leiwang...@gmail.com> wrote: > > > > 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 > >> >
