---

layout: news_item date: “2020-07-24 11:30:00 +0800” author: chunwei version: 1.24.0 categories: [release] tag: v1-24-0 sha: 4b5b9100e59ae4a43424156c9beabec6805f3d7c

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

This release comes about two months after 1.23.0. It includes more than 80 resolved issues, comprising a lot of new features as well as performance improvements and bug-fixes. Among others, it is worth highlighting the following.

• Support top-down rule applying and upper bound space pruning
• Support OFFSET parameter in TUMBLE/HOP table functions
• A new Presto dialect implementation
• Hoist, a utility to replace literals in a SQL string with placeholders