Improvements
- Optimized query rewrite for materialized views (MVs).
- Supports rewriting queries with Outer Join and Cross Join. #18629
- Optimized the data scan logic for MVs, further accelerating the rewritten queries. #18629
- Enhanced rewrite capabilities for single-table aggregate queries. #18629
- Enhanced rewrite capabilities in View Delta scenarios, which is when the queried tables are a subset of the MV's base tables. #18800
- Optimized the performance and memory usage when the window function RANK() is used as a filter or a sort key. #17553
Bug Fixes
The following bugs are fixed:
- Errors caused by null literals [] in ARRAY data. #18563
- Misuse of the low-cardinality optimization dictionary in some complex query scenarios. The dictionary mapping check is now added before applying the dictionary. #17318
- In a single BE environment, Local Shuffle causes GROUP BY to produce duplicate results. #17845
- Misuses of partition-related PROPERTIES for a non-partitioned MV may cause the MV refresh to fail. The partition PROPERTIES check is now performed when users create an MV. #18741
- Errors in parsing Parquet Repetition columns. #17626 #17788 #18051
- The obtained column's nullable information is incorrect. Solution: When CTAS is used to create a Primary Key table, only the primary key columns are non-nullable; non-primary key columns are nullable. #16431
- Some issues caused by deleting data from Primary Key tables. #18768