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 (
DELETE), windowed aggregates (
IS NOT NULLoperators.
- 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 syntax:
MINUSas a synonym for
AS JSONoption for the
- 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:
SUBSTRING applied to binary types.
There are minor but potentially breaking API changes in
SubQueryConverter and some
similar changes in the case of classes and methods) and
Visitor, and create a new class
See the cases for more details.