sql

sql copied to clipboard

Cannot use the IN clause within the SUM method

1

**Describe the bug** Hello everyone, Is there anyone here familiar with using SQL on OpenSearch? We are encountering errors when running our queries and would greatly appreciate any assistance or...

idamerce

push down project

1

LantaoJin

Prune old in operator push down rules

1

### Description [Describe what this change achieves] ### Related Issues Resolves https://github.com/opensearch-project/sql/issues/4931 ### Check List - [ ] New functionality includes testing. - [ ] New functionality has been documented....

qianheng-aws

Dedup pushdown (TopHits Agg) should work with Object fields

2

### Description #4844 converted `dedup` to TopHits Agg. But failed to parse dedup column if the column is a child of Object field. #4360 restored the internal primitive value in...

LantaoJin

[AUTO] Increment version to 3.5.0-SNAPSHOT

1

- Incremented version to **3.5.0-SNAPSHOT**.

opensearch-trigger-bot[bot]

[AUTO] Increment version to 2.19.5-SNAPSHOT

1

- Incremented version to **2.19.5-SNAPSHOT**.

opensearch-trigger-bot[bot]

Add Frequently Used Big5 PPL Queries

2

### Description This PR continues the work done in PR #4816 to add frequent used queries to the big5 workload based on gap analysis between existing benchmarks and frequent used...

aalva500-prog

[RFC] Support Schema-on-Read in PPL

2

## 1. Summary This RFC proposes a solution for OpenSearch PPL to support schema-on-read data sources where fields and types are unknown until data reading begins. The proposal focuses on...

ykmr1224

Support enumerable TopK

1

### Description Support enumerable TopK, check #4982 for details. The `CalciteEnumerableTopK` is derived from `EnumerableLimitSort` which has the corrected cost computation. ### Related Issues Resolves #4982 ### Check List -...

LantaoJin

Use Calcite's validation system for type checking & coercion

4

### Description Previously, we have implemented our own type checking mechanism due to a lacking of SQL validation phase, which relies on `SqlNode`, and compatibility issues with user-defined types. With...

yuancu