Version 2.0.0.0

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

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

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 v1.0.0

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 #306
• [sql-cli]wrap error response into exception by @zhongnansu in #309
• [SQL-CLI] set version number to 1.0.0 by @zhongnansu in #381
• [sql-cli-1.0] Rename opensearch-sql-cli to opensearch-sqlcli to unblock release by @zhongnansu in #391
• [sql-cli-1.0] rename package name of sql-cli from opensearch-sqlcli to opensearchsql by @zhongnansu in #393

Version 1.2.2.0

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

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

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)

Version 1.1.0.1

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)

Version 1.1.0.0

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)

Version 1.0.0.0

Compatible with OpenSearch and OpenSearch Dashboards Version 1.0.0

Enhancements

• Support querying a data stream (#56)

Bug Fixes

• Bug Fix: Enable legacy settings in new setting action (#97)
• Fix NPE for SHOW statement without filter (#150)

OpenSearch Migration

• Remove debug logging in ODBC driver (#27)
• Update workbench nav category to opensearch (#28)
• fix opendistro related renaming for sql-cli (#29)
• Fix issue of workbench not outputting errors (#32)
• Update issue template with multiple labels (#34)
• SQL/PPL and JDBC package renaming (#54)
• Upgrade dependencies to address high severity CVE-2021-20270 (#61)
• ODBC folder, file and code renaming (#62)
• Update workbench documentation links, complete renaming (#67)
• Update sqli-cli documentation links to OpenSearch (#72)
• Remove opensearch.sql.engine.new.enabled setting (#70)
• SQL/PPL API endpoint backward compatibility (#66)
• Remove opensearch.sql.query.analysis.* related settings (#76)
• Remove opensearch.sql.query.response.format setting (#77)
• Migrate #1097: Adding support to NOT REGEXP_QUERY (#79)
• Migrate #1083: Support long literals in SQL/PPL (#80)
• Change strategy to test connectivity between ODBC driver and SQL plugin (#69)
• Remove cursor enabling and fetch size setting (#75)
• Disable DELETE clause by defaut and add opensearch.sql.delete.enabled setting (#81)
• Support Plugin Settings Backwards Compatibility (#82)
• Updated icon and background images in ODBC installers (#84)
• Build SQL/PPL against OpenSearch rc1 and rename artifacts (#83)
• Support text functions ASCII, LEFT, LOCATE, REPLACE in new engine (#88)
• Update PowerBI custom connector .mez file for ODBC driver (#90)
• Rename remaining beta1 references in sql-cli/workbench (#91)
• Build SQL/PPL against OpenSearch 1.0 branch (#94)
• Bump OpenSearch Dashboards version to 1.0 in Workbench (#98)
• Add Integtest.sh for OpenSearch integtest setups (#128)
• Merge develop into main (#142)
• Build against OpenSearch 1.0.0 and bump artifact version to 1.0.0.0 (#146)

Documentation

• Migrate SQL/PPL, JDBC, ODBC docs to OpenSearch (#68)
• Level up README markdown (#148)

Infrastructure

• Bump glob-parent from 5.1.1 to 5.1.2 in /workbench (#125)