Chen Dai
Chen Dai
### Describe the issue I tried to use this `MinMaxAnalysisUtil` to analyze distribution of column. It worked well on small data set, however threw exception on my TPC-H dataset which...
**Feature requested** As a developer, I want this feature in order to leverage Hyperspace index in Presto/Trino. Not sure if this is similar request as https://github.com/microsoft/hyperspace/issues/514. I'm wondering if anyone...
### Describe the issue I'm wondering if what-if API mentioned in Hyperspace available for index recommendation? I checked docs, blogs and PRs but couldn't find anything related. Did I miss...
Support Elasticsearch meta fields, ex. `_id`, `_index` etc.
Because geo function support is missing in new engine, the following falls back to old engine which cannot handle. May need to add support for common geo functions. ``` SELECT...
Inconsistency found in aggregate queries between old and new engine. In old engine, aggregate queries return 200 rows by default which is same as non-aggregate queries. But in new engine,...
Currently the workbench seems showing "[Index name]: no response" for any error.
In PR https://github.com/opendistro-for-elasticsearch/sql/pull/985, a new type `UNDEFINED` is added in SQL plugin for NULL literal. This is mapping to JDBC NULL type in JDBC driver. We need to do this...
In SQL, `DISTINCT *` is used to get distinct row in result set. Currently an empty result is returned for queries as below: ``` POST _opendistro/_sql { "query": """ SELECT...
@jingyali-apr Thanks for confirming! I may have found where things go wrong: https://github.com/opensearch-project/sql/blob/907019cc8f7ce05c34ed453a75e4d897f55b57c5/sql/src/main/java/org/opensearch/sql/sql/parser/AstSortBuilder.java#L53 When we try to replace alias in `ORDER BY`, we only replace ordinal or alias directly. In...