StarRocks, a Linux Foundation project, is a next-generation sub-second MPP OLAP database for full analytics scenarios, including multi-dimensional analytics, real-time analytics, and ad-hoc queries. StarRocks received InfoWorld’s 2023 BOSSIE Award for best open source software.

StarRocks

image.png

I was working through <https://docs.starrocks.io/docs/3.5/loading/minio/#loading-into-an-existing-table-using-insert|this> part of the data loading from MinIO example when I ran across some odd behavior. After I created the table and loaded the data from the parquet file I ran this query: `SELECT DISTINCT BehaviorType FROM user_behavior_declared ORDER BY BehaviorType;` I got back 8 duplicates of each Behavior Type , not a distinct result. When I recreated the table and changed the bucketing to from hash to random, and ran the same query, the results where distinct, as expected. Is there a reason for this behavior that I am missing? Thank you.

Another new discovery is that if I use an ALTER TABLE statement to change the bucketing type to RANDOM, then back to HASH, I get distinct values.

are u able to upgrade version to 4.0.6 and test again ?

4.0.6 gives me distinct results. Was there an issue that would have caused this odd behavior in versions prior to 4.0.6?

ye, it is possible a known issue with bug fixed already , 4.0.8 will be a production ready version , before this could have some bug still

Could you please point me to the issue in the bug tracker?