@Rocky should i used Starrock 4.0.9 or 4.0.8?

As a general rule for StarRocks, you should use the latest patch version within a minor release (in this case, 4.0.x) because it includes all the bug fixes and security improvements from previous versions. Given your choice, StarRocks 4.0.9 is the recommended version over 4.0.8. Why Choose 4.0.9? Released in early April 2026, version 4.0.9 addresses several critical bugs and stability issues found in 4.0.8, including: * Restoration Fixes: Fixed an issue where the data version was not set correctly when restoring a tablet from backup. * External Catalog Improvements: Resolved a bug where table comments were not correctly set when creating Hive tables. * Iceberg Stability: Fixed failures in Iceberg materialized view refreshes when snapshot timestamps were non-monotonic. * Security & Audit: Fixed scenarios where the root user might not correctly bypass Ranger permission checks and addressed potential thread exits in the

AuditEventProcessor

during OutOfMemory (OOM) events. * Query Engine Precision: Fixed a bug in constant folding where double-precision arithmetic could incorrectly produce

INF

instead of returning an error. Key Highlights of 4.0.x If you are moving to the 4.0 series, you also benefit from the major features introduced in this branch: * 60% Faster Performance: Significant optimizations in JOINs, aggregations, and spill handling. * First-class JSON Support: 3–15× faster queries on JSON data without the need for flattening. * Advanced Iceberg Integration: Improved metadata parsing and support for hidden partitions. * Operational Ease: Features like node blacklisting and global connection IDs for easier debugging. Recommendation: If you are starting a new deployment or upgrading an existing 4.0.x cluster, go with 4.0.9. If you are currently on 4.0.8 and experiencing stability issues with Hive/Iceberg or backup/restore operations, you should plan an upgrade to 4.0.9 as soon as possible. References • release_notes/release-3.0.md • release_notes/release-3.4.md • release_notes/release-4.0.md