This is an automated email from the ASF dual-hosted git repository.
github-actions[bot] pushed a commit to branch site
in repository https://gitbox.apache.org/repos/asf/calcite.git
The following commit(s) were added to refs/heads/site by this push:
new df49590cab [CALCITE-7544] Add news item for 1.42.0
df49590cab is described below
commit df49590cab5dcc66e42c93685ced28f72afd0a04
Author: Stamatis Zampetakis <[email protected]>
AuthorDate: Sun May 31 16:23:43 2026 +0200
[CALCITE-7544] Add news item for 1.42.0
---
site/_docs/history.md | 4 +--
site/_posts/2026-05-31-release-1.42.0.md | 44 ++++++++++++++++++++++++++++++++
2 files changed, 46 insertions(+), 2 deletions(-)
diff --git a/site/_docs/history.md b/site/_docs/history.md
index 149ef7d38e..c3e06b841f 100644
--- a/site/_docs/history.md
+++ b/site/_docs/history.md
@@ -73,11 +73,11 @@ #### Web site and documentation
{: #site-1-43-0}
-->
-## <a
href="https://github.com/apache/calcite/releases/tag/calcite-1.42.0";>1.42.0</a>
/ 2026-06-01
+## <a
href="https://github.com/apache/calcite/releases/tag/calcite-1.42.0";>1.42.0</a>
/ 2026-05-31
{: #v1-42-0}
This release comes 7 months after [1.41.0](#v1-41-0),
-contains contributions from 39 contributors, and resolves 241 issues.
+contains contributions from 39 contributors, and resolves 249 issues.
Contributors to this release:
Alessandro Solimando,
diff --git a/site/_posts/2026-05-31-release-1.42.0.md
b/site/_posts/2026-05-31-release-1.42.0.md
new file mode 100644
index 0000000000..9160dcf2dc
--- /dev/null
+++ b/site/_posts/2026-05-31-release-1.42.0.md
@@ -0,0 +1,44 @@
+---
+layout: news_item
+date: "2026-05-31 14:00:00 +0000"
+author: zabetak
+version: 1.42.0
+categories: [release]
+tag: v1-42-0
+sha: c01f6b5519d4a906cf41bbe7843f5929662cf5fd
+---
+<!--
+{% comment %}
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to you under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+{% endcomment %}
+-->
+
+The [Apache Calcite PMC]({{ site.baseurl }}) is pleased to announce
+[Apache Calcite release 1.42.0]({{ site.baseurl }}/docs/history.html#v1-42-0).
+
+This release comes 7 months after [1.41.0](#v1-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.
