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 >> >
