The Apache Calcite PMC is pleased to announce Apache Calcite release 1.42.0.

This release comes 7 months after 1.41.0, contains contributions from 39 contributors, and resolves 249 issues.

Highlights include the implementation of a new decorrelation algorithm based on a research article by Neumann & Kemper; a major contribution that addresses multiple decorrelation bugs. Additional features include support for custom delimiters when parsing CSV tables, new SQL syntax extensions such as SELECT ... BY,SELECT * EXCLUDE(columns), ROW(*) for nested row types, and SELECT * REPLACE(expr as column), ':' variant path access syntax. The release also introduces several new functions—such as HYPOT (Spark), AGE (PostgreSQL), ABS, CONCAT, and SUBSTRING (MongoDB), and REGEXP (Hive)—along with improvements like simplifying certain array and division expressions, improved tracking of input fields, and new rules for transforming queries into filtered aggregates. Other enhancements include large plan optimization mode for the HepPlanner, and enhanced parser capabilities for hints with mixed assignments.

See the release notes; download the release.