sql

sql copied to clipboard

(moved from [opensearch-spark#602](https://github.com/opensearch-project/opensearch-spark/issues/602) since this issue is for SQL repository) **Is your feature request related to a problem?** Currently in async-query-core, we have three models which store the async query...

ykmr1224

**What is the bug?** The COUNT function counts the number of elements in all array values rather than counting the number of array values. Consider an index with the following...

normanj-bitquill

Fix a regression issue of parsing datetime string with custom time format in Span

5

### Description This seems a regression issue from https://github.com/opensearch-project/sql/pull/2762. Query of StatsBy with Span on a custom formatted date type will fail. Here is the reproduce: ``` PUT /ltjin-test1 {...

LantaoJin

**What is the bug?** The `JOIN` query does not support the multi_match function in the `WHERE` clause due to table alias missing. This limitation arises due to two primary reasons:...

dai-chen

This is a component issue for `2.19.0`. Coming from https://github.com/opensearch-project/opensearch-build/issues/5152. Please follow the following checklist. __Please refer to the DATES in that post__. How to use this issue ## This...

opensearch-trigger-bot[bot]

**Is your feature request related to a problem?** When evaluating an expression and it throws an exception, the message does not include the expression that failed. A query may contain...

normanj-bitquill

dynamic field type(flat_obejct) value missing

1

dynamic field type(flat_obejct) field are missing from returned query result. For instance requestParameter and responseElement field of cloudtrail logs are commonly mapped to flat_object field type to avoid mapping explosion...

kedbirhan

[BUG] Internal server error on incorrect syntax

1

**What is the bug?** ``` { "datasource" : "mys3", "lang" : "sql", "query" : "ALTER MATERIALIZED VIEW mys3.default.`mv-v10` WITH (auto_refresh = false)" } { "status": 500, "error": { "type": "SyntaxCheckException",...

noCharger

Array values are preserved (#1300) (#3095) (#3120)

1

(cherry picked from commit e109417bb3ce770fb54cfd7b231b8219a22ed46f) By submitting this pull request, I confirm that my contribution is made under the terms of the Apache 2.0 license. For more information on following...

noCharger

**What is the bug?** Instead of using the proper SQL syntax `SELECT * FROM ... WHERE ...`, when running `SELECT *FROM ... WHERE ...` (notice missing space between * and...

seankao-az