sql

sql copied to clipboard

[FEATURE] - Support pagination for PPL and SQL query

3

**Is your feature request related to a problem?** * [The new engine fetches a default size of index from OpenSearch set by this setting, the default value is 200](https://github.com/opensearch-project/sql/blob/main/docs/user/admin/settings.rst#plugins-query-size-limit). It...

penghuo

Extend size_limit setting in query engine to support unlimited index query.

7

## Problem statements Currently, the query.size_limit [setting](https://github.com/opensearch-project/sql/blob/main/docs/user/ppl/admin/settings.rst#plugins-query-size-limit) configure the maximum amount of documents to be pull from OpenSearch. The default value is: 200. for example, Let's say size_limit = 200,...

penghuo

OpenSearch function support

1

**Is your feature request related to a problem? Please describe.** Currently both SQL (new engine) and PPL doesn't support any OpenSearch functions. We should prioritize this, especially the most common...

dai-chen

**Is your feature request related to a problem? Please describe.** Plugins such as Observability depends on PPL to generate metrics and retrieve data for visualization. The requests are from Kibana...

zhongnansu

[BUG] Memory usage exceed limit and java.lang.IllegalStateException: resource is not enough to run the query, quit.

1

**Describe the bug** Memory used up after many sql requests was executed. **To Reproduce** Steps to reproduce the behavior: 1. start a new container from the opensearch docker image v1.2.3;...

microtimber

* Handle back-pressure exception.

penghuo

penghuo

[BUG] Expressions in PPL require whitespace around * characters

5

**What is the bug?** If a multiplication expression is written without whitespace around the operator, the lexer mistakenly tokenizes it as `ID_LITERAL`. This leads to unexpected behavior (and IMHO wrong...

kroepke

_plugins/_sql/_explain is not working as described in documentation

3

# Description Endpoint _plugins/_sql/_explain is not working as described in documentation. ## Documentation states: > Description > > To translate your query, send it to explain endpoint. The explain output...

atompie

## 1.Overview In this document, we will propose a solution in OpenSearch Observability to query log data stored in S3. ### 1.1.Problem Statements Currently, OpenSearch Observability is collection of plugins...

penghuo