Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[FEATURE] Support ExistsSubQuery PPL #711

Closed
LantaoJin opened this issue Sep 29, 2024 · 0 comments · Fixed by #769
Closed

[FEATURE] Support ExistsSubQuery PPL #711

LantaoJin opened this issue Sep 29, 2024 · 0 comments · Fixed by #769
Assignees
Labels
0.6 enhancement New feature or request Lang:PPL Pipe Processing Language support

Comments

@LantaoJin
Copy link
Member

LantaoJin commented Sep 29, 2024

Is your feature request related to a problem?
Sub-task of #661

What solution would you like?

  1. correlated condition:

SQL usage

SELECT  *
FROM    a
WHERE   EXISTS (SELECT  *
                FROM    b
                WHERE   b.id = a.id)

PPL usage

source=a | where exists [
  source=b | where b.id = a.id
]
  1. uncorrelated condition:

SQL usage

SELECT  *
FROM    a
WHERE   EXISTS (SELECT  *
                FROM    b
                WHERE   b.id > 10)

PPL usage

source=a | where exists [
  source=b | where b.id > 10
]

What alternatives have you considered?
A clear and concise description of any alternative solutions or features you've considered.

Do you have any additional context?
Add any other context or screenshots about the feature request here.

@LantaoJin LantaoJin added enhancement New feature or request untriaged labels Sep 29, 2024
@YANG-DB YANG-DB added Lang:PPL Pipe Processing Language support and removed untriaged labels Sep 30, 2024
@LantaoJin LantaoJin moved this to In Progress in PPL Commands Oct 8, 2024
@YANG-DB YANG-DB added the 0.6 label Oct 9, 2024
@LantaoJin LantaoJin self-assigned this Oct 10, 2024
@github-project-automation github-project-automation bot moved this from In Progress to Done in PPL Commands Oct 12, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
0.6 enhancement New feature or request Lang:PPL Pipe Processing Language support
Projects
Status: Done
Development

Successfully merging a pull request may close this issue.

2 participants