Query your data using familiar SQL or intuitive Piped Processing Language (PPL)
Compatible with OpenSearch and OpenSearch Dashboards Version 2.9.0
protocol.rst
with new wording for error message (#1662)Compatible with OpenSearch and OpenSearch Dashboards Version 2.8.0
Release date: June 6th, 2023
2.x
. (#1650)SINH
function to V2 engine by @matthewryanwells in https://github.com/opensearch-project/sql/pull/1437
RINT
function to V2 engine by @matthewryanwells in https://github.com/opensearch-project/sql/pull/1439
sec_to_time
Function To OpenSearch SQL by @GabeFernandez310 in https://github.com/opensearch-project/sql/pull/1438
WEEKDAY
Function to SQL Plugin by @GabeFernandez310 in https://github.com/opensearch-project/sql/pull/1440
YEARWEEK
Function To OpenSearch SQL by @GabeFernandez310 in https://github.com/opensearch-project/sql/pull/1445
EXTRACT
Function To OpenSearch SQL Plugin by @GabeFernandez310 in https://github.com/opensearch-project/sql/pull/1443
STR_TO_DATE
Function To The SQL Plugin by @GabeFernandez310 in https://github.com/opensearch-project/sql/pull/1444
TO_SECONDS
Function To The SQL Plugin by @GabeFernandez310 in https://github.com/opensearch-project/sql/pull/1447
SIGNUM
function to V2 engine by @matthewryanwells in https://github.com/opensearch-project/sql/pull/1442
TIMESTAMPADD
Function To OpenSearch SQL Plugin by @GabeFernandez310 in https://github.com/opensearch-project/sql/pull/1453
OpenSearchDataType
: parse, store and use mapping information by @Yury-Fridlyand in https://github.com/opensearch-project/sql/pull/1455
Timestampdiff
Function To OpenSearch SQL by @GabeFernandez310 in https://github.com/opensearch-project/sql/pull/1472
Full Changelog: https://github.com/opensearch-project/sql/compare/2.6.0.0...2.7.0.0
Compatible with OpenSearch and OpenSearch Dashboards Version 2.6.0
GET_FORMAT
Function To OpenSearch SQL Plugin (#1342)GET_FORMAT
Function (#1349)last_day
Function To OpenSearch SQL Plugin (#1350)concat()
string function to support multiple string arguments (#1297)DATE_ADD
/ADDDATE
and DATE_SUB
/SUBDATE
functions. (#122) (#1325)TIMESTAMP
function implementation and signatures. (#1340)TIME_FORMAT()
Function To SQL Plugin (#1346)Compatible with OpenSearch and OpenSearch Dashboards Version 2.5.0
TIMEDIFF
and DATEDIFF
functions. (#131 #1195 #1234)ADDTIME
and SUBTIME
. (#132 #1194 #1252)TIME
Type in DAY_OF_YEAR Functions (#199 #1223 1#258)FLOAT
-> DOUBLE
cast. (#1025)query
function as alternate syntax to query_string
function (#1010)Compatible with OpenSearch and OpenSearch Dashboards Version 2.4.0
FROM_UNIXTIME
and UNIX_TIMESTAMP
(#835)CONVERT_TZ
and DATETIME
functions to SQL and PPL (#848)typeof
function. (#867)PERIOD_ADD
and PERIOD_DIFF
. (#933)min
, max
and avg
(#1022)name
option. (#904)jackson-databind
for sql-jdbc
only (#943)Compatible with OpenSearch and OpenSearch Dashboards Version 2.3.0
Compatible with OpenSearch and OpenSearch Dashboards Version 2.2.0
query_string
Relevance Function Implementation in SQL and PPL (#675)jackson-databind
for sql-jdbc
only #943@forestmvey, @GumpacG and @dai-chen for their valuable contribution.
Please, see unsigned binaries below:
The signed driver should be published on Maven repository soon.