sql

sql copied to clipboard

[META]PPL Add `CIDR` IP range command support

1

**Description:** We propose adding a CIDR (Classless Inter-Domain Routing) function to OpenSearch's Piped Processing Language (PPL) to provide built-in IP address range matching capabilities. This feature would be similar to...

YANG-DB

[META]Add `fillnull` command to PPL

1

**Description:** We propose adding a `fillnull` command to OpenSearch's Piped Processing Language (PPL) to provide a convenient way to handle null or missing values in query results. This feature would...

YANG-DB

[FEATURE] support `subquery` in PPL

1

## Problem we are solving for * An SRE or Security Analyst needs to filter data based on the result of another query or filter. * An SRE or Security...

brijos

Improve the branching strategy in the code around SQL_PAGINATION_API_SEARCH_AFTER check

1

We have introduced SQL_PAGINATION_API_SEARCH_AFTER config settings to choose the approach used for pagination queries. The default value is true today which uses Point in time with search_after API to paginate...

manasvinibs

allow show tables extended and show databases commands in security la…

1

### Description allow show tables extended and show databases commands in security lake datasource sql queries ### Related Issues Resolves #[Issue number to be closed when this PR is merged]...

eirsep

[RFC] Support JOIN command in PPL

8

**Is your feature request related to a problem?** Current JOIN syntax is only available in SQL query due to the implementation of JOIN is in v1 engine only. To support...

LantaoJin

Enhance OS value parsing

1

### Description #3001 ### Related Issues Resolves #3001 ### Check List - [x] New functionality includes testing. - [x] New functionality has been documented. - [x] New functionality has javadoc...

bugmakerrrrrr

**Is your feature request related to a problem?** OpenSearch Piped Processing Language (PPL) currently lacks a native command to flatten nested objects or arrays in documents. Many datasets, especially those...

YANG-DB

**Is your feature request related to a problem?** OpenSearch Piped Processing Language (PPL) currently lacks a native command to flatten nested objects or arrays in documents. Many datasets, especially those...

YANG-DB

**Is your feature request related to a problem?** We need to enhance OpenSearch PPL (Piped Processing Language) by adding support for JSON-based operations. This extension will provide users with powerful...

YANG-DB