sql

sql copied to clipboard

Fix unit test in PowerBI connector.

1

Signed-off-by: Yury-Fridlyand ### Description Last time we updated PowerBI connector, we missed to update embedded unit tests. These tests may be executed by a developer only. To run tests you...

Yury-Fridlyand

Add implementation of `now`, `sysdate`, `localtime` and similar functions

1

Signed-off-by: Yury Fridlyand ### Description New functions added: * now() * current_timestamp() * localtimestamp() * localtime() * sysdate() * curtime() * current_time() * curdate() * current_date() New signatures: * `now()`...

Yury-Fridlyand

[BUG] `SUM(const)` fails with IllegalStateException

1

User scenario: 1. Install Tableau 2. Install ODBC driver 3. Configure driver 4. Connect to it (without using OpenSearch connector) 5. Perform data refresh from a table  Under the...

Yury-Fridlyand

SQL ingestion and ops - standup

36

**Is your feature request related to a problem?** A clear and concise description of what the problem is, e.g. _I'm always frustrated when [...]_ **What solution would you like?** A...

anirudha

@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...

dai-chen

[BUG] LIKE escape special characters with '\' not working

5

**What is the bug?** We followed MySQL syntax and tried to escape special character like '%' and '_' with the escape char ‘\\', because MySQL uses '\\' as the escape...

chloe-zh

[Backport 2.x] Change master node timeout to new API

1

Backport 4e40ed2839889be44008037154173392d0907f20 from #793

opensearch-trigger-bot[bot]

[BUG] IS NOT NULL with alias throws SemanticCheckException

9

**Describe the bug** Using `IS NOT NULL` with alias throws SemanticCheckException. **To Reproduce** Sample query: ``` SELECT dest_city_name AS dc FROM all_flights WHERE dc IS NOT NULL ``` **Expected behavior**...

ankurgupta4891

[AUTO] Increment version to 2.3.0-SNAPSHOT

1

- Incremented version to **2.3.0-SNAPSHOT**.

opensearch-trigger-bot[bot]

[BUG] SQL query doesn't honor date format in OpenSearch index mapping

4

**What is the bug?** It seems SQL query engine doesn't honor what's configured in OpenSearch index mapping for date field. This causes problems in different queries with datetime field involved....

dai-chen