Skip to content
This repository has been archived by the owner on Aug 2, 2022. It is now read-only.

Releases: opendistro-for-elasticsearch/sql

Version 0.8.0.0

05 Apr 18:39
Compare
Choose a tag to compare
  • Feature #12: Add support for Elasticsearch 6.6.2
  • Bug fix #9: Fix issue for query by index pattern in JDBC driver.
  • Bug fix #10: Return friendly error message instead of NPE for illegal query and other exception cases.

Version 0.7.0.0

05 Apr 18:42
Compare
Choose a tag to compare

Notable Changes

In this release, the following features are added with many other minor improvements and bug fixes.

  • SQL HAVING:
    • Add support for SQL HAVING to filter aggregated result after GROUP BY.
  • SQL Functions:
    • Common math functions as well as date function are available.
  • Nested Field Query:
    • Query nested field in SQL++ syntax instead of explicit nested() function.
  • JSON in RESTful Request:
    • Support JSON payload to allow for ESRally benchmark and parameters in JDBC request. And also pretty format and flatten native Elasticsearch DSL as response.
  • Block Hash Join:
    • Introduced new query planning framework and new hash join algorithm with memory protection mechanism to perform hash join block by block safely.

Major Refactoring & Architecture Changes

  • Avoid I/O Operation in NIO Thread
    • Move I/O blocking operations to custom worker thread pool or prefetch to avoid blocking. Meanwhile non-blocking operations still run in Elasticsearch transport thread for efficiency.