---

layout: news_item date: “2019-09-11 21:40:00 +0000” author: zabetak version: 1.21.0 categories: [release] tag: v1-21-0 sha: adc1532de853060d24fd0129257a3fae306fb55c

The [Apache Calcite PMC]({{ site.baseurl }}) is pleased to announce [Apache Calcite release 1.21.0]({{ site.baseurl }}/docs/history.html#v1-21-0).

This release comes two months after 1.20.0. It includes more than 100 resolved issues, comprising a large number of new features as well as general improvements and bug-fixes.

It is worth highlighting that Calcite now:

• supports implicit type coercion in various contexts (CALCITE-2302);
• allows transformations of Pig Latin scripts into algebraic plans (CALCITE-3122);
• provides an implementation for the main features of MATCH_RECOGNIZE in the Enumerable convention (CALCITE-1935);
• supports correlated ANY/SOME/ALL sub-queries (CALCITE-3031);
• introduces anonymous types based on ROW, ARRAY, and nested collection (CALCITE-3233, CALCITE-3231, CALCITE-3250);
• brings new join algorithms for the Enumerable convention (CALCITE-2979, CALCITE-2973, CALCITE-3284).