Opensearch Project Sql Versions Save

Version 2.1.0.0 Release Notes

Compatible with OpenSearch and OpenSearch Dashboards Version 2.1.0

Features

• Support match_phrase filter function in SQL and PPL (#604)
• Add implementation for simple_query_string relevance search function in SQL and PPL (#635)
• Add multi_match to SQL plugin (#649)
• Integ match bool prefix #187 (#634)
• PPL describe command (#646)

Maintenance

• change plugin folder name to opensearch-sql-plugin (#670)
• Version bump to 2.1.0 and gradle version bump (#655)

Bug Fixes

• Integ replace junit assertthat with hamcrest import (#616)
• Integ relevance function it fix (#608)
• Fix merge conflict on function name (#664)
• Fix fuzziness parsing in multi_match function. Update tests. (#668)
• ODBC SSL Compliance Fix (#653)

Infrastructure

• Match Query Unit Tests (#614)
• Uses custom plugin to publish zips to maven (#638)

Version 2.0.0.0 Release Notes

Compatible with OpenSearch and OpenSearch Dashboards Version 2.0.0.0

Features

• Add Kmeans and AD command documentation (#493)
• AD and Kmeans grammar edits (#500)
• Support more parameters for AD and KMEANS command, and update related documentation (#515)

Maintenance

• Version 2.0 (#507)
• Removed changes introduced to support JDK8 (#513)
• Add JDK 17 support (#512)
• Upgrade OS Version to 2.0.0-alpha1-SNAPSHOT (#518)
• Add alpha1 qualifiers for dashboards plugin (#523)
• 2.0 build fix (#535)
• Change ODBC version to 1.4 for release (#542)
• Change workbench alpha1 to rc1 for first 2.0 release (#545)
• Change 2.0-alpha1 to 2.0-rc1. (#555)
• Replace checked-in ml-commons dependency for 2.0 (#563)
• Delete ml-commons zip file (#565)
• bump ml-client to 2.0 (#568)
• Remove rc1 qualifier for 2.0 (#600)

Infrastructure

• Fix bwc build issue with jdk17 (#520)
• Updated issue templates from .github. (#531)
• Removing JDK14 from CI (#547)
• Replace checked-in ZIP with a dynamic dependency (#514)

Bug Fixes

• Bump async from 3.2.0 to 3.2.3 in /workbench (#559)
• Bump moment from 2.29.1 to 2.29.2 in /workbench (#546)
• Version Bump: spring-beans-5.2.19 -> spring-beans-5.2.20 (#527)
• Bug Fix, return default ID when log4j ThreadContext is empty (#538)
• Removed ES reference from build.gradle (#562)

Documentation

• Change master nomenclature (#551)
• Change blacklist and whitelist nomenclature (#560)

Version 2.0.0.0-rc1 Release Notes

Compatible with OpenSearch and OpenSearch Dashboards Version 2.0.0.0-rc1

Features

• Add Kmeans and AD command documentation (#493)
• AD and Kmeans grammar edits (#500)
• Support more parameters for AD and KMEANS command, and update related documentation (#515)

Maintenance

• Version 2.0 (#507)
• Removed changes introduced to support JDK8 (#513)
• Add JDK 17 support (#512)
• Upgrade OS Version to 2.0.0-alpha1-SNAPSHOT (#518)
• Add alpha1 qualifiers for dashboards plugin (#523)
• 2.0 build fix (#535)
• Change ODBC version to 1.4 for release (#542)
• Change workbench alpha1 to rc1 for first 2.0 release (#545)
• Change 2.0-alpha1 to 2.0-rc1. (#555)
• Replace checked-in ml-commons dependency for 2.0 (#563)
• Delete ml-commons zip file (#565)
• bump ml-client to 2.0 (#568)

Infrastructure

• Fix bwc build issue with jdk17 (#520)
• Updated issue templates from .github. (#531)
• Removing JDK14 from CI (#547)
• Replace checked-in ZIP with a dynamic dependency (#514)

Bug Fixes

• Bump async from 3.2.0 to 3.2.3 in /workbench (#559)
• Bump moment from 2.29.1 to 2.29.2 in /workbench (#546)
• Version Bump: spring-beans-5.2.19 -> spring-beans-5.2.20 (#527)
• Bug Fix, return default ID when log4j ThreadContext is empty (#538)
• Removed ES reference from build.gradle (#562)

Documentation

• Change master nomenclature (#551)
• Change blacklist and whitelist nomenclature (#560)

Version 1.3.0.0 Release Notes

Compatible with OpenSearch and OpenSearch Dashboards Version 1.3.0

Features

• Add parse command to PPL (#411)
• PPL integration with AD and ml-commons (#468)

Enhancements

• Support ISO 8601 Format in Date Format. (#460)
• Add Certificate Validation option (#449)
• Span expression should always be first in by list if exist (#437)
• Support multiple indices in PPL and SQL (#408)
• Support combination of group field and span in stats command (#417)
• Support In clause in SQL and PPL (#420)
• Add cast function to PPL (#433)
• [Enhancement] optimize sort rewrite logic (#434)

Bug Fixes

• Fix certificate validation for ODBC driver (#479)
• Update dependency opensearch-ml-client group name (#477)
• Treating ExpressionEvaluationException as client Error. (#459)
• Version Bump: H2 1.x -> 2.x (#444)
• Version Bump: springframework and jackson (#443)
• Bug Fix, disable html escape when formatting response (#412)
• Jackson-databind bump to 2.12.6 (#410)
• Parse none type field as null instead of throw exception (#406)

Documentation

• Add parse docs to PPL commands index (#486)
• Add limitation section in PPL docs (#456)
• Add how to setup aws credentials for ODBC Tableau (#394)

Maintenance

• Add JDK 8 to CI Matrix (#483)
• Add CI Matrix for JDK 11 and 14 (#451)
• Update backport and add auto-delete workflows (#446)
• Add auto backport functionality for SQL (#445)
• Version bump to 1.3 (#419)
• Revert to windows 2019 for odbc CI (#413)

Infrastructure

• Disable flaky test in JdbcTestIT. (#475)

SQL-CLI Version 1.0.0

• initial release of OpenSearch SQL CLI
• publish on Pypi https://pypi.org/project/opensearchsql/

What's Changed

• use opensearch-py client by @zhongnansu in https://github.com/opensearch-project/sql/pull/306
• [sql-cli]wrap error response into exception by @zhongnansu in https://github.com/opensearch-project/sql/pull/309
• [SQL-CLI] set version number to 1.0.0 by @zhongnansu in https://github.com/opensearch-project/sql/pull/381
• [sql-cli-1.0] Rename opensearch-sql-cli to opensearch-sqlcli to unblock release by @zhongnansu in https://github.com/opensearch-project/sql/pull/391
• [sql-cli-1.0] rename package name of sql-cli from opensearch-sqlcli to opensearchsql by @zhongnansu in https://github.com/opensearch-project/sql/pull/393

Version 1.2.2.0 Release Notes

Compatible with OpenSearch Version 1.2.2, OpenSearch Dashboards 1.2.0

Bug fixes

• Bump log4j to 2.16 and plugin to 1.2.2 (#338)

Version 1.2.1.0 Release Notes

Compatible with OpenSearch and OpenSearch Dashboards Version 1.2.1

Bug fixes

• Bumping log4j to 2.15.0 (#324)

Version 1.2.0.0 Release Notes

Compatible with OpenSearch and OpenSearch Dashboards Version 1.2.0

Features

• Add new protocol for visualization response format (#251)

Enhancements

• Add conversion support for datetime as per https://github.com/kylepbi… (#267)
• Optimized type converting in DSL filters (#272)

Documentation

• Create 1.2 release notes (#268)
• Update notice files (#269)
• Update license header (#282)
• Updated PPL user manual with relevance function limitations (#283)

Maintenance

• Bumps version to 1.2 (#254)

2021-10-28 Version 1.1.0.1

Compatible with OpenSearch and OpenSearch Dashboards Version 1.1.0

Enhancements

• Support match function as filter in SQL and PPL (#204)
• Renamed plugin helper config file to consistent name with OSD (#228)
• Support ODBC compatibility with ODFE SQL (#238)
• Support span aggregation in query engine (#220)

Bug Fixes

• Fix PPL request concurrency handling issue (#207)
• Changed the ODBC mac installer build platform to MacOS 10.15 from latest (#230)

Infrastructure

• Removed integtest.sh. (#208)
• Update build to use public Maven repo (#225)
• Address security vulnerability CVE-2021-3795 (#231)
• Addressed security vulnerability CVE-2021-3807 (#233)
• Enable DCO Workflow Check (#242)

2021-09-02 Version 1.1.0.0

Compatible with OpenSearch and OpenSearch Dashboards Version 1.1.0

Enhancements

• Support implicit type conversion from string to boolean (#166)
• Support distinct count aggregation (#167)
• Support implicit type conversion from string to temporal (#171)
• Workbench: auto dump cypress test data, support security (#199)

Bug Fixes

• Fix for SQL-ODBC AWS Init and Shutdown Behaviour (#163)
• Fix import path for cypress constant (#201)

Infrastructure

• Add Integtest.sh for OpenSearch integtest setups (workbench) (#157)
• Bump path-parse from 1.0.6 to 1.0.7 in /workbench (#178)
• Use externally-defined OpenSearch version when specified. (#179)
• Use OpenSearch 1.1 and build snapshot by default in CI. (#181)
• Workbench: remove curl commands in integtest.sh (#200)
• Bump opensearch ref to 1.1 in CI (#205)