Thanks Julian! -- Jesús
On 1/9/17, 8:38 AM, "Julian Hyde" <[email protected]> wrote: >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 >
