The [Apache Calcite PMC]({{ site.baseurl }}) is pleased to announce [Apache Calcite release 1.36.0]({{ site.baseurl }}/docs/history.html#v1-36-0).
This release comes 3 months after 1.35.0, contains contributions from 30 contributors, and resolves 125 issues.
Among other new features, it's worth highlighting the adding of 30 new SQL functions in various libraries such as BigQuery and Spark, many improvements hardening TABLESAMPLE
, and also the following features:
WITH
queriesCREATE TABLE ... LIKE DDL
in server moduleLEFT ANTI JOIN
in Babel parserLIMIT start, ALL
in MySQL conformance, equivalent to OFFSET start
RelRule
that converts Minus
into UNION ALL..GROUP BY...WHERE
In addition to new features, it's also worth highlighting the integrating of SQL Logic Test suite