Apache Drill 1.21.0
Apache Drill 1.21.0 highlights include
- A major upgrade of the parsing and planning library Calcite from 1.21 to 1.33 enabled by the elimination of Drill’s fork of Calcite.
- Upgrades of most format plugins to the internal EVF2 reader framework included support for provided schemas.
- A new native Drill storage plugin enabling “Drill-on-Drill” federated deployments.
- INSERT support, currently in the JDBC, Splunk and Google Sheets plugins. * New SQL syntax including filtered aggregates, PIVOT, UNPIVOT, INTERSECT and EXCEPT.
- Support for new authentication modes in storage plugins including user translation for using different external credentials for different Drill users.
- An overhaul of the implicit type casting logic for a more consistent user experience.
- New functions and storage plugins including Delta Lake, Google Sheets, MS Access, threat hunting functions and statistical distribution functions.
See the release notes for more.