Version 2.5.0

Compatible with OpenSearch and OpenSearch Dashboards Version 2.5.0

Refactoring

• The SQL Plugin was rearranged into separate repositories (#640 #1263)
• Added SQL-Jdbc repository https://github.com/opensearch-project/sql-jdbc (#964)
• Added SQL-Jdbc maven artifact as a dependency (#2692)
• Added SQL-Odbc repository https://github.com/opensearch-project/sql-odbc (#965)
• Added SQL-Cli repository https://github.com/opensearch-project/sql-cli (#966)
• Added Workbench repository https://github.com/opensearch-project/dashboards-query-workbench (#1266)

Enhancements

• Add low-level create table and table exists API (#834)
• Add time window and window assigner (#950)
• Add valueOf() to Expression (#1055)
• Add Statement, QueryExecution and QueryManager (#845)
• Add Streaming Source Impl (#994)
• Add watermark generator (#959)
• Add stream context and window trigger (#958)
• Add micro batch streaming execution (#1044)
• Add Streaming Plan Impl (#1068)
• Add CBRT to the V2 engine (#1081)
• Add CBRT function to the PPL (#1097)
• Add timeout option to SQL CLI tool. (#1076)
• Add Day_Of_Year Function To OpenSearch (#1128)
• Add Week_Of_Year Function To OpenSearch (#1127)
• Add Month_Of_Year Function To OpenSearch (#1129)
• Add Minute_Of_Day Function To SQL Plugin (#1207 #1214)
• Add Second_Of_Minute Function As An Alias Of The Second Function (#1231 #1237)
• Add Support For Legacy Syntax For Match Function In New Engine (#1090)
• Add MatchPhraseQuery As Alternate Syntax for Match_Phrase Function (#1103)
• Use query execution start time as the value of now-like functions. (#1047)
• Add Support for Alternate Legacy MULTIMATCH syntax (#1102)
• Add position() function to V2 engine (#1121)
• Add position() string function to PPL (#1147)
• Add support for wildcard_query function to the new engine (#156 #1108)
• Add reverse() string function to V2 SQL Engine(#1154)
• Add table write operator and builder (#1094)
• Add BETWEEN expression in v2 engine (#1163)
• Adding UTC_DATE, UTC_TIME, UTC_TIMESTAMP (#1193 #1198)
• Validate field and fields parameters in relevance search functions (#1067 #1199)
• Add TIMEDIFF and DATEDIFF functions. (#131 #1195 #1234)
• Add functions ADDTIME and SUBTIME. (#132 #1194 #1252)
• Add Day_Of_Week Function As An Alias Of DayOfWeek (#190 #1228 #1239)
• Add Minute_Of_Hour Function As An Alias Of Minute Function (#1253)
• Add support for long value return for CEIL, CEILING and FLOOR math functions (#1205)
• Add Alternate Syntax For Match_Query And Other Functions (#1166)
• Add Support For TIME Type in DAY_OF_YEAR Functions (#199 #1223 1#258)
• Add Day_Of_Month Function As An Alias Of DayOfMonth (#1227 #1265)
• Add security patch for CVE-2020-15250 (#1095)
• Add security patch for CVE-2022-45868 (#1107)
• Add Hour_Of_Day Function As An Alias Of Hour (#1226 #1270)

Bug Fixes

• Fix FLOAT -> DOUBLE cast. (#1025)
• Fix error messaging from prometheus. (#1029 #1037)
• Add query function as alternate syntax to query_string function (#1010)
• Deprecate span collector (#990)
• back quote fix (#1041 #1050)
• Update DATE and TIME functions to parse string input as datetime (#991)
• Integ tests fix for arm64 (#1069)
• Fix history file usage in SQL CLI tool. (#1077)
• Update Jackson to 2.14.1 and fix dependency resolution issues (#1150)
• Change LIKE operator case-insensitive match (#1160)
• Fix arithmetic operator precedence (#1172 #1188)
• Fix back quoted alias of FROM subquery (#1189 #1208)
• Fix truncate function (#1197 #1213)
• Allow common keywords and scalar function name used as identifier (#1191 #1212)
• Suppress report uploading failure in CI. (#1180 #1220)
• Fixed error with single timestamp query (#1244 #1246 #1249)
• Support JOIN query on object field with unexpanded name (#1229 #1250)
• Bug fix for less than and greater than operators on @timestamp (#1267 #1272)

Infrastructure

• Change ApplicationContext lifecycle to per node level (#822)
• Catalog to Datasource changes (#1027 #1049 #1086)
• Bump jackson to 2.14.0 (#1058)
• Add metadatalog interface and default in memory implementation (#974)
• Decouple function repository and DSL from IoC container for use anywhere (#1085)
• Move DataSourceServiceImpl to core module (#1084)
• Improve pushdown optimization and logical to physical transformation (#1091)
• Using jackson and jackson_databind version defined in OpenSearch (#1169 #1173)
• Add BWC tests for running against distribution bundle. (#1209)

Documentation

• Support opensearch-sql:run and update developer_guide doc (#1099)
• Updated MAINTAINERS.md to match recommended opensearch-project format. (#1224 #1233)