www-announce mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Julian Hyde <jh...@apache.org>
Subject [ANNOUNCE] Apache Calcite 1.11.0 released
Date Mon, 09 Jan 2017 08:37:06 GMT
The Apache Calcite team is pleased to announce the release of Apache
Calcite 1.11.0.

Calcite is a dynamic data management framework. Its cost-based
optimizer converts queries, represented in relational algebra, into
executable plans. Calcite supports many front-end languages and
back-end data engines, and includes an SQL parser and, as a
sub-project, the Avatica JDBC driver.

Nearly three months after the previous release, there is a long list
of improvements and bug-fixes, many of them making planner rules
smarter. The following are some of the more important ones.

Several adapters have improvements:
* The JDBC adapter can now push down DML (INSERT, UPDATE, DELETE),
  windowed aggregates (OVER), IS NULL and IS NOT NULL operators.
* The Cassandra adapter now supports authentication.
* Several key bug-fixes in the Druid adapter.

For correlated and uncorrelated sub-queries, we generate more
efficient plans (for example, in some correlated queries we no longer
require a sub-query to generate the values of the correlating
variable), can now handle multiple correlations, and have also fixed a
few correctness bugs.

New SQL features:
* CROSS APPLY and OUTER APPLY;
* MINUS as a synonym for EXCEPT;
* an "AS JSON" option for the EXPLAIN command;
* compound identifiers in the target list of INSERT, allowing you to
  insert into individual fields of record-valued columns (or column
  families if you are using the Apache Phoenix adapter);
* a variety of new and extended built-in functions: CONVERT, LTRIM,
  RTRIM, 3-parameter LOCATE and POSITION, RAND, RAND_INTEGER, and
  SUBSTRING applied to binary types.

There are minor but potentially breaking API changes in [CALCITE-1519]
(interface SubqueryConverter becomes SubQueryConverter and some
similar changes in the case of classes and methods) and [CALCITE-1530]
(rename Shuttle to Visitor, and create a new class Visitor<R>). See
the cases for more details.

You can start using it in Maven by simply updating your dependency to:

  <dependency>
    <groupId>org.apache.calcite</groupId>
    <artifactId>calcite-core</artifactId>
    <version>1.11.0</version>
  </dependency>

If you'd like to download the source release, you can find it here:

  http://www.apache.org/dyn/closer.cgi/calcite/apache-calcite-1.11.0/

You can read more about the release (including release notes) here:

  http://calcite.apache.org/news/2017/01/09/release-1.11.0/

We welcome your help and feedback. For more information on how to
report problems, and to get involved, visit the project website at:

   http://calcite.apache.org/

Thanks to everyone involved!

Julian Hyde, on behalf of the Apache Calcite Team

Mime
View raw message