forked from opendistro-for-elasticsearch/sql
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathopendistro-elasticsearch-sql.release-notes
More file actions
130 lines (90 loc) · 8.71 KB
/
opendistro-elasticsearch-sql.release-notes
File metadata and controls
130 lines (90 loc) · 8.71 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
## 2019-10-29, Version 1.3.0 (Current)
### Notable changes
* Feature [#258](https://github.com/opendistro-for-elasticsearch/sql/issues/185): Elasticsearch 7.3.2 compatibility
* Feature [#201](https://github.com/opendistro-for-elasticsearch/sql/pull/201): Improve query verification by adding semantic analyzer
* Enhancement [#262](https://github.com/opendistro-for-elasticsearch/sql/pull/262): Support CASE statement in one more grammer
* Enhancement [#253](https://github.com/opendistro-for-elasticsearch/sql/pull/253): Support Cast function
* Enhancement [#260](https://github.com/opendistro-for-elasticsearch/sql/pull/260): Support string operators: ASCII, RTRIM, LTRIM, LOCATE, LENGTH, REPLACE
* Enhancement [#254](https://github.com/opendistro-for-elasticsearch/sql/issues/254): Support SELECT <number_literal>
* Enhancement [#251](https://github.com/opendistro-for-elasticsearch/sql/pull/251): Support number operators: POWER, ATAN2, COT, SIGN/SIGNUM
* Enhancement [#215](https://github.com/opendistro-for-elasticsearch/sql/issues215): Support ordinal in GROUP/ORDER BY clause
* Enhancement [#213](https://github.com/opendistro-for-elasticsearch/sql/issues/213): Support <table>.<column> syntax
* Enhancement [#212](https://github.com/opendistro-for-elasticsearch/sql/issues/212): Support Quoted identifiers
* Enhancement [#199](https://github.com/opendistro-for-elasticsearch/sql/issues/199): Support NOT operator with nested field query
* Enhancement [#166](https://github.com/opendistro-for-elasticsearch/sql/issues/166): Support pretty option for explain request
* Enhancement [#162](https://github.com/opendistro-for-elasticsearch/sql/issues/162): Support ORDER BY for 2 or more columns sorts only by last column in aggregation query
* Enhancement [#151](https://github.com/opendistro-for-elasticsearch/sql/issues/151): Improve query verification and exception handling
* Enhancement [#128](https://github.com/opendistro-for-elasticsearch/sql/issues/128): Support case-changing functions
* Enhancement [#120](https://github.com/opendistro-for-elasticsearch/sql/issues/120): Support aggregation function in HAVING
* Enhancement [#82](https://github.com/opendistro-for-elasticsearch/sql/issues/82): Pre-verification before actual execution of query
* Enhancement [#75](https://github.com/opendistro-for-elasticsearch/sql/issues/75): Support order by on SQL functions like SUM etc
* BugFix [#265](https://github.com/opendistro-for-elasticsearch/sql/pull/265): Fix the LOG function that delivered inaccurate result
* BugFix [#233](https://github.com/opendistro-for-elasticsearch/sql/issues/233): Function names are case-sensitive
* BugFix [#191](https://github.com/opendistro-for-elasticsearch/sql/issues/191): Fix new syntax check for LEFT JOIN on nested field and metadata field
* BugFix [#188](https://github.com/opendistro-for-elasticsearch/sql/issues/188): Having doesn't working on nested field
* BugFix [#187](https://github.com/opendistro-for-elasticsearch/sql/issues/187): Aggregation on Nested Array Field return unexpected value
* BugFix [#186](https://github.com/opendistro-for-elasticsearch/sql/issues/186): Alias of group key is not returned correctly
* BugFix [#176](https://github.com/opendistro-for-elasticsearch/sql/issues/176): ORDER BY expects function names written only in lowercase
* BugFix [#175](https://github.com/opendistro-for-elasticsearch/sql/issues/175): ORDER BY doesn't respect table aliases
* BugFix [#170](https://github.com/opendistro-for-elasticsearch/sql/issues/170): Some flaky test cases fail and pass after retry
* BugFix [#158](https://github.com/opendistro-for-elasticsearch/sql/issues/158): Aliases aren't working for ORDER BY and GROUP BY
* BugFix [#132](https://github.com/opendistro-for-elasticsearch/sql/issues/132): Integration Test Cluster doesn't terminated when integration test failed
* BugFix [#125](https://github.com/opendistro-for-elasticsearch/sql/issues/125): Parsing Exception when WHERE clause has true/false in CONDITION
* BugFix [#122](https://github.com/opendistro-for-elasticsearch/sql/issues/122): Query with custom-function doesn't respect LIMIT
* BugFix [#121](https://github.com/opendistro-for-elasticsearch/sql/issues/121): Dot/period at start of index name fails to parse
* BugFix [#111](https://github.com/opendistro-for-elasticsearch/sql/issues/111): JDBC format of aggregation query with date_format adds unnecessary column bug
## 2019-10-15, Version 1.2.1
### Notable changes
* Feature [#202](https://github.com/opendistro-for-elasticsearch/sql/issues/202): Elasticsearch 7.2.1 compatibility
## 2019-07-23, Version 1.2.0
### Notable changes
* Feature [#125](https://github.com/opendistro-for-elasticsearch/sql/issues/125): Elasticsearch 7.2.0 compatibility
* Feature [#103](https://github.com/opendistro-for-elasticsearch/sql/issues/103): Sort on custom script based functions
* BugFix [#104](https://github.com/opendistro-for-elasticsearch/sql/issues/104): GROUP BY and ORDER BY for custom script based functions
generated wrong DSL
* BugFix [#95](https://github.com/opendistro-for-elasticsearch/sql/issues/95): NPE thrown when selecting all in query with nested fields involved
* BugFix [#108](https://github.com/opendistro-for-elasticsearch/sql/issues/108): Custom script based functions weren't supported in JDBC
and other minor bugfixes
## 2019-06-21, Version 1.1.0
### Notable Changes
* Feature [#90](https://github.com/opendistro-for-elasticsearch/sql/issues/90): Elasticsearch 7.1.1 compatibility
* Migration [#17](https://github.com/opendistro-for-elasticsearch/sql/issues/17): Finished integ test migration and deprecated Maven build.
* Enhancement [#34](https://github.com/opendistro-for-elasticsearch/sql/issues/34): Detached request ID from SqlRequest object.
* BugFix [#46](https://github.com/opendistro-for-elasticsearch/sql/issues/46): Multi-index queries require identical mappings for indices.
* BugFix [#92](https://github.com/opendistro-for-elasticsearch/sql/issues/92): Improper handling of SELECT statement
* BugFix [#93](https://github.com/opendistro-for-elasticsearch/sql/issues/93): Blank query causes IndexOutOfBoundsException
## 2019-06-10, Version 1.0.0
### Notable Changes
* Feature [#47](https://github.com/opendistro-for-elasticsearch/sql/issues/47): Support for Elasticsearch 7.0.1.
* Feature [#56](https://github.com/opendistro-for-elasticsearch/sql/issues/56): Adding coverage report.
* Feature [#65](https://github.com/opendistro-for-elasticsearch/sql/issues/65): Support for enabling/disabling SQL feature.
* BugFix [#44](https://github.com/opendistro-for-elasticsearch/sql/issues/44): Fixing the order of fields in csv output
* BugFix [#68](https://github.com/opendistro-for-elasticsearch/sql/issues/68): Support number field
* BugFix [#37](https://github.com/opendistro-for-elasticsearch/sql/issues/37): Fix for PERCENTILES query result in csv output
## 2019-04-19, Version 0.9.0
### Notable Changes
* Feature [#29](https://github.com/opendistro-for-elasticsearch/sql/issues/29): Add support for Elasticsearch 6.7.1
* Migration [#17](https://github.com/opendistro-for-elasticsearch/sql/issues/17): Migrate legacy integration tests in Maven to ES test in Gradle.
## 2019-04-02, Version 0.8.0
### Notable Changes
* Feature [#12](https://github.com/opendistro-for-elasticsearch/sql/issues/12): Add support for Elasticsearch 6.6.2
* Bug fix [#9](https://github.com/opendistro-for-elasticsearch/sql/issues/9): Fix issue for query by index pattern in JDBC driver.
* Bug fix [#10](https://github.com/opendistro-for-elasticsearch/sql/issues/10): Return friendly error message instead of NPE for illegal query and other exception cases.
## 2019-03-11, Version 0.7.0
### 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.
### Commits
* [[`56dd269`](https://github.com/mauve-hedgehog/opendistro-elasticsearch-sql/commit/56dd269871259dae9fb77ab512005b9a714d728e)] Initial commit