============= Release 0.257

Details

General Changes

Fix queries failing with EXCEEDED_LOCAL_MEMORY_LIMIT error due to incorrect memory tracking while reading spilled data.
Fix deadlock for queries with JOIN and LIMIT with spilling enabled.
Fix query failures due to expressions with multiple is null checks on the same variable.
Improve memory usage of queries spilling in the join operator.
Improve expressions printed in query plans to be closer to valid SQL.
Add support to find the n-th instance in :func:!array_position.
Add support for correlated subqueries with complex expressions in the correlation.
Add support for the OFFSET clause in SQL query expressions. This feature can be enabled by setting the session property offset_clause_enabled or configuration property offset-clause-enabled to true.

Hive Changes

Fix a bug in reading Avro format table with schema located in a Kerberos enabled HDFS compliant filesystem.
Fix dynamic pruning for null keys in hive partition.

Contributors

Abhisek Gautam Saikia, Andrii Rosa, Arjun Gupta, Basar Hamdi Onat, Chen, George Wang, Grace Xin, Huameng Jiang, James Petty, James Sun, Masha Basmanova, Mayank Garg, Rebecca Schlussel, Rohit Jain, Roman Zeyde, Rongrong Zhong, Saumitra Shahapure, Seba Villalobos, Sergey Pershin, Sergii Druzkin, Shixuan Fan, Swapnil Tailor, Timothy Meehan, Venki Korukanti, Vic Zhang, Xiang Fu, Zhenxiao Luo, beinan, prithvip, tanjialiang