You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@calcite.apache.org by jh...@apache.org on 2021/10/15 01:33:38 UTC
[calcite] 03/03: [CALCITE-4835] Release Calcite 1.28.0
This is an automated email from the ASF dual-hosted git repository.
jhyde pushed a commit to branch stage
in repository https://gitbox.apache.org/repos/asf/calcite.git
commit a77133f6a7345bf0a8b895dd2e747198a08a1e62
Author: Julian Hyde <jh...@apache.org>
AuthorDate: Thu Oct 14 00:02:30 2021 -0700
[CALCITE-4835] Release Calcite 1.28.0
---
site/_docs/history.md | 335 +++++++++++++++++++++++++++++++++++++++++++++++++-
site/_docs/howto.md | 5 +
2 files changed, 337 insertions(+), 3 deletions(-)
diff --git a/site/_docs/history.md b/site/_docs/history.md
index 8b77775..a0d3f88 100644
--- a/site/_docs/history.md
+++ b/site/_docs/history.md
@@ -28,14 +28,326 @@ For a full list of releases, see
Downloads are available on the
[downloads page]({{ site.baseurl }}/downloads/).
-## <a href="https://github.com/apache/calcite/releases/tag/calcite-1.28.0">1.28.0</a> / under development
+## <a href="https://github.com/apache/calcite/releases/tag/calcite-1.28.0">1.28.0</a> / 2021-10-19
{: #v1-28-0}
+This release comes four months after [1.27.0](#v1-27-0),
+contains contributions from 38 authors,
+and resolves 76 issues.
+New features include the
+<a href="https://issues.apache.org/jira/browse/CALCITE-4486">UNIQUE</a>
+sub-query predicate, the
+<a href="https://issues.apache.org/jira/browse/CALCITE-4661">MODE</a> aggregate function,
+<a href="https://issues.apache.org/jira/browse/CALCITE-4644">PERCENTILE_CONT and PERCENTILE_DISC</a>
+inverse distribution functions, an
+<a href="https://issues.apache.org/jira/browse/CALCITE-4614">Exasol dialect</a>
+for the JDBC adapter, and improvements to
+<a href="https://issues.apache.org/jira/browse/CALCITE-4779">materialized</a>
+<a href="https://issues.apache.org/jira/browse/CALCITE-3935">view</a>
+<a href="https://issues.apache.org/jira/browse/CALCITE-4774">recognition</a>.
+Two APIs are deprecated and will be [removed in release 1.29](#to-be-removed-in-1-29-0).
+
Compatibility: This release is tested on Linux, macOS, Microsoft Windows;
using JDK/OpenJDK versions 8 to 15;
Guava versions 19.0 to 31.0.1-jre;
other software versions as specified in gradle.properties.
+Contributors to this release:
+Alessandro Solimando,
+Alon Eldar,
+Amir Gajst,
+Bruce Irschick,
+dz,
+Evgeniy Stanilovskiy,
+Feng Zhu,
+Grzegorz Gierlach,
+Haisheng Yuan,
+Jack Scott,
+Jacky Yin,
+Jacques Nadeau,
+James Starr,
+Jesus Camacho Rodriguez,
+Jianhui Dong,
+Jiasen Sheng,
+Julian Hyde (release manager),
+Liu Enze,
+Michael Mior,
+Narayanan Venkateswaran,
+Nick Riasanovsky,
+NobiGo,
+Rafay Qureshi,
+Ruben Q L,
+Sergey Nuyanzin,
+Stamatis Zampetakis,
+Taras Ledkov,
+Thomas Rebele,
+TJ Banghart,
+Ulrich Kramer,
+Vladimir Ozerov,
+Vladimir Sitnikov,
+Will Noble,
+Xurenhe,
+Yanjing Wang,
+Yingyu Wang,
+YuKong.
+
+#### Deprecated for removal next release
+{: #to-be-removed-in-1-29-0}
+
+* In 1.28,
+ [<a href="https://issues.apache.org/jira/browse/CALCITE-4787">CALCITE-4787</a>]
+ added `class Immutables` and deprecated `ImmutableBeans`; in 1.29,
+ [<a href="https://issues.apache.org/jira/browse/CALCITE-4839">CALCITE-4839</a>]
+ will remove `ImmutableBeans`
+* In 1.28,
+ [<a href="https://issues.apache.org/jira/browse/CALCITE-4795">CALCITE-4795</a>]
+ deprecated the `operands` field of `SqlBasicCall`. Before 1.29, we will make
+ that field private.
+
+#### New features
+
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4719">CALCITE-4719</a>]
+ Add variants of `RexSubQuery` that collect sub-queries into `MULTISET`, `ARRAY`
+ and `MAP` collections
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-3524">CALCITE-3524</a>]
+ In `RelBuilder`, add methods for creating various kinds of sub-query
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-2736">CALCITE-2736</a>]
+ `ReduceExpressionsRule` never reduces dynamic expressions but this should be
+ configurable
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4847">CALCITE-4847</a>]
+ Parse SQL with BigQuery-style quoted identifiers and character literals
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4805">CALCITE-4805</a>]
+ Calcite should convert a small `IN`-list as if the user had written `OR`, even
+ if the `IN`-list contains `NULL`
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4779">CALCITE-4779</a>]
+ If `GROUP BY` clause contains literal, materialized view recognition fails
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4486">CALCITE-4486</a>]
+ `UNIQUE` sub-query
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-3935">CALCITE-3935</a>]
+ Enhance join materialization, support to pull-up filters under join of left or
+ right
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4767">CALCITE-4767</a>]
+ JDBC adapter wrongly quotes backticks inside BigQuery identifiers
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4774">CALCITE-4774</a>]
+ Materialized view recognition fails for equivalent predicates
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4742">CALCITE-4742</a>]
+ Implement `SOME <>` sub-query
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4726">CALCITE-4726</a>]
+ Support aggregate calls with a `FILTER` clause in
+ `AggregateExpandWithinDistinctRule`
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4748">CALCITE-4748</a>]
+ If there are duplicate `GROUPING SETS`, Calcite should return duplicate rows
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4665">CALCITE-4665</a>]
+ Allow `Aggregate.groupKey` to be a strict superset of `Aggregate.groupKeys`
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4724">CALCITE-4724</a>]
+ In JDBC adapter for ClickHouse, implement `Values` by generating `SELECT`
+ without `FROM`
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4673">CALCITE-4673</a>]
+ If arguments to a table function are correlation variables, `SqlToRelConverter`
+ should eliminate duplicate variables
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4642">CALCITE-4642</a>]
+ Use `RelDataTypeSystem` from `Config` in `Planner`
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4661">CALCITE-4661</a>]
+ Add `MODE` aggregate function
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4420">CALCITE-4420</a>]
+ Some simple arithmetic operations can be simplified
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4640">CALCITE-4640</a>]
+ Propagate table scan hints to JDBC
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4668">CALCITE-4668</a>]
+ `RelBuilder.join` should convert `Correlate` to `Join` if correlation variable
+ is unused
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4644">CALCITE-4644</a>]
+ Add `PERCENTILE_CONT` and `PERCENTILE_DISC` functions
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4614">CALCITE-4614</a>]
+ Exasol dialect implementation
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4158">CALCITE-4158</a>]
+ In generated SQL, "`*`" should be followed by space
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4606">CALCITE-4606</a>]
+ In Elasticsearch adapter, translate `SEARCH` call to `termsQuery`
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4499">CALCITE-4499</a>]
+ `FilterJoinRule` misses opportunity to push `Filter` to `SemiJoin` input
+
+#### Bug-fixes, API changes and minor enhancements
+
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4848">CALCITE-4848</a>]
+ Adding a `HAVING` condition to a query with a dynamic parameter makes the result
+ always empty
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4550">CALCITE-4550</a>]
+ Simplify `JaninoRelMetadataProvider` API for binding methods
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4740">CALCITE-4740</a>]
+ JDBC adapter generates incorrect `HAVING` clause in BigQuery dialect
+* Refactor: Introduce field `SqlUtil.GENERATED_EXPR_ALIAS_PREFIX`
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4616">CALCITE-4616</a>]
+ `AggregateUnionTransposeRule` causes row type mismatch when some inputs have
+ unique grouping key
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4795">CALCITE-4795</a>]
+ In class `SqlBasicCall`, deprecated the `operands` field
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4628">CALCITE-4628</a>]
+ If `SqlImplementor` fails, include the `RelNode` in the exception
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4757">CALCITE-4757</a>]
+ In Avatica, support columns of type `NULL` in query results
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4602">CALCITE-4602</a>]
+ `ClassCastException` retrieving from `ARRAY` that has mixed `INTEGER` and
+ `DECIMAL` elements
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4600">CALCITE-4600</a>]
+ `ClassCastException` retrieving from an `ARRAY` that has `DATE`, `TIME` or
+ `TIMESTAMP` elements
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-3338">CALCITE-3338</a>]
+ Error with `executeBatch` and `preparedStatement` when using `RemoteMeta`
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4811">CALCITE-4811</a>]
+ `Coalesce(null, row)` fails with `NullPointerException`
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-3583">CALCITE-3583</a>]
+ `Exchange` operator deserialize fails when the `RexInput` has no `RelCollation`
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-3745">CALCITE-3745</a>]
+ `CompileException` in `UnitCompiler` when using multiple class loaders
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4834">CALCITE-4834</a>]
+ `JaninoRelMetadataProvider` uses hardcoded class name
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4819">CALCITE-4819</a>]
+ `SemiJoin` operator is not skipped in materialized view-based rewriting
+ algorithm
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4546">CALCITE-4546</a>]
+ Change metadata dispatch to avoid registration of all `RelNode` subtypes
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4787">CALCITE-4787</a>]
+ Replace `ImmutableBeans` with `Immutables` in `core` module
+ * [<a href="https://issues.apache.org/jira/browse/CALCITE-4830">CALCITE-4830</a>]
+ Remove remaining uses of `ImmutableBeans` and deprecate
+ * [<a href="https://issues.apache.org/jira/browse/CALCITE-4825">CALCITE-4825</a>]
+ Move remaining core/main off of `ImmutableBeans`
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4532">CALCITE-4532</a>]
+ Correct code generated for primitive-object `ConstantExpression`
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-3409">CALCITE-3409</a>]
+ Add a method in `RelOptMaterializations` to allow registering `UnifyRule`
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4773">CALCITE-4773</a>]
+ `RelDecorrelator`'s `RemoveSingleAggregateRule` can produce result with wrong
+ row type
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4544">CALCITE-4544</a>]
+ Deprecate `Metadata` API backed by Java Reflection
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4772">CALCITE-4772</a>]
+ `PushProjector` should retain alias when handling `RexCall`
+* Remove obsolete/misleading comments in `RelOptUtil#classifyFilters`
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4784">CALCITE-4784</a>]
+ Ensure `Correlate#requiredColumns` is subset of columns in left relation
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4177">CALCITE-4177</a>]
+ `RelJson` should throw if asked to deserialize a call to an unknown operator
+* Add `RelBuilder.lessThan`, and use `RelBuilder` shorthands
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4766">CALCITE-4766</a>]
+ Remove unreachable code from `SqlValidatorImpl#performUnconditionalRewrites`
+ for `Values` node
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4747">CALCITE-4747</a>]
+ In `HepPlanner`, remove outdated graph edges
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4760">CALCITE-4760</a>]
+ `RelBuilder` creation fails with error '`No suitable driver found for
+ jdbc:calcite:`' in shaded Calcite
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4584">CALCITE-4584</a>]
+ Using function in `PARTITION BY` list of `OVER` window causes conversion
+ exception
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4734">CALCITE-4734</a>]
+ If there are duplicate `RexNode` in `MutableCalc`, `SubstitutionVisitor` should
+ return right rebuild `RexNode`
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4741">CALCITE-4741</a>]
+ `AbstractRelNode#getId` can overflow into a negative value, causing
+ `CompileException` in the `implement` methods of certain `Enumerable`
+ sub-classes
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4652">CALCITE-4652</a>]
+ `AggregateExpandDistinctAggregatesRule` must cast top aggregates to original
+ type
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4716">CALCITE-4716</a>]
+ `ClassCastException` converting Sarg in `RelNode` to SQL
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4706">CALCITE-4706</a>]
+ JDBC adapter generates casts exceeding Redshift's data types bounds
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4485">CALCITE-4485</a>]
+ JDBC adapter generates invalid SQL when one of the joins is `INNER JOIN ... ON
+ TRUE`
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4623">CALCITE-4623</a>]
+ `SemiJoinRule` should not match semi-join
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4692">CALCITE-4692</a>]
+ Redshift does not support `DOUBLE` or `TINYINT` datatypes
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4690">CALCITE-4690</a>]
+ Error when executing query with `CHARACTER SET` in Redshift
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4675">CALCITE-4675</a>]
+ Error executing query with SUM and multiplication via JDBC adapter
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4674">CALCITE-4674</a>]
+ Excess quotes in generated SQL when "`*`" is a column alias
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-3775">CALCITE-3775</a>]
+ Implicit lookup methods in `SimpleCalciteSchema` ignore case sensitivity
+ parameter
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4638">CALCITE-4638</a>]
+ `VolcanoPlanner` fails to recognize transformation rule correctly in the
+ top-down mode
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4655">CALCITE-4655</a>]
+ `JdbcTable.scan` throws `NullPointerException`
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4636">CALCITE-4636</a>]
+ Switch out of agg mode when constructing `RelCollation` for aggregate functions
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4619">CALCITE-4619</a>]
+ `FULL JOIN` plan cannot be executed in MySQL
+
+#### Build and test suite
+
+* Bump JDK from 15 to 17 in seed build cache CI jobs
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4798">CALCITE-4798</a>]
+ Gradle build fails due to deprecated metadata APIs
+* Use jdk16 instead of jdk17 since jdk17 is not yet available at AppVeyor
+* Fix string reference to `HrSchema` in `MaterializationTest` with
+ `HrSchema.class.getName()`
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4829">CALCITE-4829</a>]
+ Bump Gradle to 7.2 and test with Java 17 at GitHub Actions
+* Fix `ErrorProne` violations in `testkit`
+* Add missing `@Override` annotations
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4821">CALCITE-4821</a>]
+ Move utility test classes into `calcite-testkit` and unpublish `-test.jar`
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4823">CALCITE-4823</a>]
+ Suppress warnings for `java.security.AccessController` deprecation
+* Skip `EqualsHashCode` verification in `ErrorProne`: it is already verified with
+ `Checkstyle`
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4790">CALCITE-4790</a>]
+ Make Gradle pass the `user.timezone` property to the test JVM
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4793">CALCITE-4793</a>]
+ `CassandraAdapterDataTypesTest.testCollectionsInnerValues` fails depending on
+ the user timezone
+* Replace deprecated `com.google.common.io.Files.createTempDir()` with
+ `java.nio.file.Files.createTempDirectory()` in ElasticSearch tests
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4789">CALCITE-4789</a>]
+ Build is broken on Guava versions < 21
+* Enable `JdbcTest#testBushy` and update expected plan
+* `RelOptRulesTest` improvements
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4312">CALCITE-4312</a>]
+ Improve content of `prepareVote` draft email
+
+#### Dependency version upgrade
+
+* Bump Guava maximum version up to 31.0.1-jre
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4762">CALCITE-4762</a>]
+ Upgrade Calcite to Avatica 1.19
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4836">CALCITE-4836</a>]
+ Upgrade protobuf-java 3.6.1 → 3.17.1
+* Bump JUnit5 to 5.8.1
+
+#### Web site and documentation
+
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4835">CALCITE-4835</a>]
+ Release Calcite 1.28.0
+* Site: Pronouns, talks
+* Site: Add Zhaohui Xu as committer
+* Site: Update fengzhu's organization and add pronouns
+* Site: Remove vote email from release instructions, and minor improvements
+* Site: Add upcoming talk about Morel and update past talks section
+* Site: Remove contributors name from commit summary
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4656">CALCITE-4656</a>]
+ Broken CI links on develop web page
+* [<a href="https://issues.apache.org/jira/browse/CALCITE-4796">CALCITE-4796</a>]
+ Travis links in `README.md` should point to `app.travis-ci.com` instead of
+ `travis-ci.org`
+* Site: HTTP to HTTPS redirection is not working
+* Site: Add zabetak's pronouns
+* Site: Add michaelmior's pronouns
+* Site: Update jhyde's organization and add pronouns
+* Site is not published due to bad yaml file suffix
+* Site: Add upcoming talk at ApacheCon'21 and info about tutorial at BOSS21
+* Site: Sort table of aggregate functions
+* Site: Deploy using `.asf.yml`
+* Site: Add Vladimir Ozerov as committer
+* Site: Remove nowadays redundant minified javascript files
+
## <a href="https://github.com/apache/calcite/releases/tag/calcite-1.27.0">1.27.0</a> / 2021-06-03
{: #v1-27-0}
@@ -57,6 +369,7 @@ Guava versions 19.0 to 29.0-jre;
other software versions as specified in gradle.properties.
#### Breaking Changes
+
* [<a href="https://issues.apache.org/jira/browse/CALCITE-4521">CALCITE-4251</a>]
Get the origin column, even if it is derived
* [<a href="https://issues.apache.org/jira/browse/CALCITE-4570">CALCITE-4570</a>]
@@ -66,6 +379,7 @@ other software versions as specified in gradle.properties.
Make `SUBSTRING` operator comply with ISO standard SQL
#### New features
+
* [<a href="https://issues.apache.org/jira/browse/CALCITE-4564">CALCITE-4564</a>]
Initialization context for non-static user-defined functions (UDFs)
* [<a href="https://issues.apache.org/jira/browse/CALCITE-4477">CALCITE-4477</a>]
@@ -112,6 +426,7 @@ other software versions as specified in gradle.properties.
`InnoDB` adapter (neoremind)
#### Bug fixes, API changes and minor enhancements
+
* [<a href="https://issues.apache.org/jira/browse/CALCITE-4497">CALCITE-4497</a>]
In `RelBuilder`, support windowed aggregate functions (OVER)
* [<a href="https://issues.apache.org/jira/browse/CALCITE-4620">CALCITE-4620</a>]
@@ -362,7 +677,9 @@ other software versions as specified in gradle.properties.
* Remove multiple blank lines after import statements
* Cleanup code after errorprone upgrade: `IdentityHashMapUsage`, `JdkObsolete` ->
`JavaUtilDate`
-#### Build and test suit
+
+#### Build and test suite
+
* [<a href="https://issues.apache.org/jira/browse/CALCITE-4613">CALCITE-4613</a>]
OWASP dependency-check tasks fail due to missing resources
* [<a href="https://issues.apache.org/jira/browse/CALCITE-4576">CALCITE-4576</a>]
@@ -418,6 +735,7 @@ other software versions as specified in gradle.properties.
Enable ErrorProne checking and resolve identified problems
#### Dependency version upgrade
+
* Bump commons-codec from 1.12 to 1.13 (Jaromir Hamala)
* [<a href="https://issues.apache.org/jira/browse/CALCITE-4528">CALCITE-4528</a>]
Upgrade Avatica version to 1.18.0
@@ -437,7 +755,9 @@ other software versions as specified in gradle.properties.
* [<a href="https://issues.apache.org/jira/browse/CALCITE-4339">CALCITE-4339</a>]
Update Gradle: 6.6 -> 6.7
* Use jackson-bom to specify Jackson versions
+
#### Web site and documentation
+
* [<a href="https://issues.apache.org/jira/browse/CALCITE-4625">CALCITE-4625</a>]
Update version in NOTICE, README, and howto.md
* [<a href="https://issues.apache.org/jira/browse/CALCITE-4601">CALCITE-4601</a>]
@@ -462,10 +782,12 @@ Guava versions 19.0 to 29.0-jre;
other software versions as specified in gradle.properties.
#### Breaking Changes
+
* [<a href="https://issues.apache.org/jira/browse/CALCITE-2082">CALCITE-2082</a>]
Do not store types or type factories inside operators
#### New features
+
* [<a href="https://issues.apache.org/jira/browse/CALCITE-4173">CALCITE-4173</a>]
Add internal `SEARCH` operator and `Sarg` literal that represents a set of values or ranges
* [<a href="https://issues.apache.org/jira/browse/CALCITE-3752">CALCITE-3752</a>]
@@ -484,6 +806,7 @@ Provide utility to visualize `RelNode` plans (Liya Fan)
Support `LEFT JOIN` in `EnumerableMergeJoin`
#### Bug fixes, API changes and minor enhancements
+
* [<a href="https://issues.apache.org/jira/browse/CALCITE-2833">CALCITE-2833</a>]
In JDBC adapter for Hive and BigQuery, implement `Values` by generating `SELECT` without `FROM` (Stuti Gupta)
* [<a href="https://issues.apache.org/jira/browse/CALCITE-4160">CALCITE-4160</a>]
@@ -611,6 +934,7 @@ Deprecate `SqlParser.ConfigBuilder`
* Minor refactoring of `DruidAdapterIT` and `DruidAdapter2IT`
#### Build and test suite
+
* [<a href="https://issues.apache.org/jira/browse/CALCITE-4278">CALCITE-4278</a>]
Add Druid adapter tests in GitHub CI
* [<a href="https://issues.apache.org/jira/browse/CALCITE-4259">CALCITE-4259</a>]
@@ -629,6 +953,7 @@ Remove dependency between checkstyle and compilation tasks
* Update `org.nosphere.apache.rat` plugin from 0.5.2 to 0.7.0, and print files with unapproved licenses to console
#### Web site and documentation
+
* [<a href="https://issues.apache.org/jira/browse/CALCITE-3841">CALCITE-3841</a>]
Change downloads page to use downloads.apache.org
* Fix documentation errors
@@ -653,6 +978,7 @@ Guava versions 19.0 to 28.2-jre; other software versions as specified in
gradle.properties.
#### Breaking Changes
+
* [<a href="https://issues.apache.org/jira/browse/CALCITE-2569">CALCITE-2569</a>]
UDFs that are table functions must implement `SqlTableFunction` and have `CURSOR` as their return type
* [<a href="https://issues.apache.org/jira/browse/CALCITE-3923">CALCITE-3923</a>]
@@ -663,6 +989,7 @@ Dialect constants in `SqlDialect` can cause class initialization deadlock
Remove dependency of File adapter on Example CSV adapter
#### New features
+
* [<a href="https://issues.apache.org/jira/browse/CALCITE-2160">CALCITE-2160</a>]
Spatial: Add functions `ST_MakeGrid` and `ST_MakeGridPoints`
* [<a href="https://issues.apache.org/jira/browse/CALCITE-4134">CALCITE-4134</a>]
@@ -673,6 +1000,7 @@ Add a rule, `ProjectAggregateMergeRule`, to merge a `Project` onto an `Aggregate
Allow character literals as column aliases, if `SqlConformance.allowCharLiteralAlias()`
#### Bug fixes, API changes and minor enhancements
+
* [<a href="https://issues.apache.org/jira/browse/CALCITE-4139">CALCITE-4139</a>]
Prevent NPE in `ListTransientTable`
* [<a href="https://issues.apache.org/jira/browse/CALCITE-2854">CALCITE-2854</a>]
@@ -693,6 +1021,7 @@ Estimate the number of distinct values more accurately (Liya Fan)
Some improvements to aggregate related operations (Liya Fan)
#### Build and test suite
+
* [<a href="https://issues.apache.org/jira/browse/CALCITE-4141">CALCITE-4141</a>]
Make checkstyle tasks relocatable to support Gradle build cache
* [<a href="https://issues.apache.org/jira/browse/CALCITE-4137">CALCITE-4137</a>]
@@ -1546,7 +1875,7 @@ generates the `ROW` keyword only if the dialect allows it (quxiucheng)
* [<a href="https://issues.apache.org/jira/browse/CALCITE-3282">CALCITE-3282</a>] In JDBC adapter, when generating SQL for Hive, generate `INTEGER` type as `INT` (huangfeng)
* [<a href="https://issues.apache.org/jira/browse/CALCITE-3335">CALCITE-3335</a>] In ElasticSearch adapter, introduce configuration parameter "hosts" which deprecates previous "coordinates" (Shikha Somani)
-#### Build and test
+#### Build and test suite
* Stop building zip archives when building using gradle
* [<a href="https://issues.apache.org/jira/browse/CALCITE-2442">CALCITE-2442</a>] Remove .toDelete cassandra temp folder on Windows after tests
diff --git a/site/_docs/howto.md b/site/_docs/howto.md
index fbbb79f..604b29e 100644
--- a/site/_docs/howto.md
+++ b/site/_docs/howto.md
@@ -727,6 +727,11 @@ Before you start:
a fix version assigned (most likely the version we are
just about to release)
+Generate list of contributors:
+```
+./sqlsh -o headers "select distinct author from git_commits where author_timestamp > DATE '2021-06-03' order by 1 "
+```
+
Smoke-test `sqlline` with Spatial and Oracle function tables:
{% highlight sql %}