Kai Huang

[GitHub Request]New Repository: opensearch-query-grammar

3

### What is the type of request? Repository Management ### Details of the request Please create a new repository in the opensearch-project org with the name opensearch-query-grammar. Initial maintainers should...

[Repository Request]New Repository: opensearch-query-grammar

9

### Are you requesting a new GitHub Repository within opensearch-project GitHub Organization? Yes ### GitHub Repository Proposal https://github.com/opensearch-project/.github/issues/333# ### GitHub Repository Additional Information 1. What is the new GitHub repository...

Backend API support for pagination

3

### Description This PR adds offset-based pagination support for PPL queries executed through the Calcite engine. Users can now paginate through large result sets by specifying pageSize and offset parameters...

Implement `reverse` performance optimization

6

### Description Originally from #4056 by @selsong This PR implements a significant performance optimization for the `reverse` command by eliminating the expensive ROW_NUMBER() window function and implementing a three-tier logic...

[BUG] `ArrayIndexOutOfBoundsException` when querying index with disabled objects containing dot-only field names

1

## Bug Description When querying an OpenSearch index that contains documents with field names consisting only of dots (e.g., `"."`, `".."`) **inside disabled objects** (`"enabled": false`), the SQL plugin throws:...

[BUG] `distinct_count_approx` does not work with array types

2

## Query Information **PPL Query:** ```ppl source = opensearch_dashboards_sample_data_ecommerce | stats distinct_count_approx(`manufacturer`) as dc ``` **Expected Result:** `distinct_count_approx` should return an approximate distinct count of the values in the `manufacturer`...