sql

sql copied to clipboard

[FEATURE] Make SQL align with PPL to support evaluate nested fields and update fields.

1

**Is your feature request related to a problem?** Currently in OpenSearch, SQL doesn't support update or evaluate nested fields like PPL. To make them align, we may need to make...

qianheng-aws

[BUG] Generic Client with Custom Deserializer fails to deserialize aggregations

1

**What is the bug?** I am using opensearch-java client 2.12.0 **Describe the issue**: I have a specific requirement where I will be using aggregations on a index, but I want...

dsinghal-nice

### Description Add a rule EvalPushDown.PUSH_DOWN_SORT, this rule will push down limit under eval. Thus, sort has chance to be pushed down into TableScanBuilder later. For now, it only supports...

qianheng-aws

### Description Allows for join operations on indexes whose names start with periods. ### Related Issues Resolves #2550 ### Check List - [X] New functionality includes testing. - [X] New...

jzonthemtn

2 Set the v2 implementation as default, keep v1's as fallback

1

2 When the feature of PPL JOIN command is stable, provide JOIN syntax in SQL then. Set the v2 implementation as default, but keep v1's as fallback util the implementation...

LantaoJin

1.5 Support join hint in PPL

1

LantaoJin

1.4 Extract join criteria from WHERE expression (equivalence set)

1

LantaoJin

1.2 Support multiple tables join in PPL

1

LantaoJin

1.1 Support two tables join in PPL (inner join, left outer join, left semi join and left anti join (type) and hash join operator (equi-join), nested loop join operator (non-equi-join))

1

LantaoJin

1.6 Support more join types (full outer, cross etc)

1

LantaoJin