layout: news_item date: “2020-03-05 17:17:00 +0800” author: danny0405 version: 1.22.0 categories: [release] tag: rel/v1.22.0 sha: 537b8dbb4b58c61b6c573eb07a51b8d38896a1ff

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

This release comes five months after 1.21.0. It includes more than 250 resolved issues, comprising a large number of new features as well as general improvements and bug-fixes. Among others, it is worth highlighting the following.

  • Supports SQL hints for different kind of relational expressions (CALCITE-482)
  • A new Redis adaptor (CALCITE-3510)
  • More Oracle and MySQL functions are supported, i.e. Oracle XML function (CALCITE-3579, CALCITE-3580), MySQL math functions (CALCITE-3684, CALCITE-3695, CALCITE-3707)

We have also fixed some important bugs:

  • The metadata cache is fixed for rare cases that RelSets are merging (CALCITE-2018)
  • The GROUP_ID now returns correct results (CALCITE-1824)
  • CORRELATE row count estimation has been fixed, it is always 1 before (CALCITE-3711)
  • The modulus precision inference of DECIMALs has been fixed (CALCITE-3435)