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.

Sign up for GitHub

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

Jump to bottom

SQL: consider adding the IN operator support #32955

Closed
astefan opened this issue Aug 17, 2018 · 2 comments
Closed

SQL: consider adding the IN operator support #32955

astefan opened this issue Aug 17, 2018 · 2 comments
Assignees
@matriv
Labels
:Analytics/SQL SQL querying >enhancement >feature v6.5.0 v7.0.0-beta1

Comments

@astefan
Copy link
Contributor

astefan commented Aug 17, 2018

At the moment the workaround for the missing IN support is to provide a long list of OR statements. It would be easier/more comfortable to use IN instead.
Related to #32942
@elasticmachine
Copy link
Collaborator

Pinging @elastic/es-search-aggs

@lanerjo
Copy link

lanerjo commented Aug 30, 2018

+1
WHERE visit.app.appName IN ('appA', 'appB') <- does not work
terms: {visit.app.appName: [appA, appB]} <- expected translation of above

WHERE visit.app.appName = appA OR visit.app.appName = appB <- very very very inconvenient workaround

@matriv matriv self-assigned this Oct 17, 2018
matriv added a commit to matriv/elasticsearch that referenced this issue Oct 18, 2018
@matriv
SQL: Implement IN(value1, value2, ...) expression.
36dca6d 
Implement the functionality to translate the
`field IN (value1, value2,...) expressions to proper Lucene queries
or painless script depending on the use case.

The `IN` expression can be used in SELECT, WHERE and HAVING clauses.

Closes: elastic#32955
This was referenced Oct 18, 2018
Merged
Closed
@andyb-elastic andyb-elastic mentioned this issue Oct 18, 2018
Closed
matriv pushed a commit that referenced this issue Oct 23, 2018
SQL: Implement IN(value1, value2, ...) expression. (#34581)
4a8386f 
Implement the functionality to translate the
`field IN (value1, value2,...)` expressions to proper Lucene queries
or painless script or local processors depending on the use case.

The `IN` expression can be used in SELECT, WHERE and HAVING clauses.

Closes: #32955
matriv pushed a commit that referenced this issue Oct 23, 2018
@matriv
SQL: Implement IN(value1, value2, ...) expression. (#34581)
528e2b2 
Implement the functionality to translate the
`field IN (value1, value2,...)` expressions to proper Lucene queries
or painless script or local processors depending on the use case.

The `IN` expression can be used in SELECT, WHERE and HAVING clauses.

Closes: #32955
kcm pushed a commit that referenced this issue Oct 30, 2018
@kcm
SQL: Implement IN(value1, value2, ...) expression. (#34581)
888ea5c 
Implement the functionality to translate the
`field IN (value1, value2,...)` expressions to proper Lucene queries
or painless script or local processors depending on the use case.

The `IN` expression can be used in SELECT, WHERE and HAVING clauses.

Closes: #32955
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@matriv matriv

Labels
:Analytics/SQL SQL querying >enhancement >feature v6.5.0 v7.0.0-beta1
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
5 participants
@colings86 @astefan @matriv @elasticmachine @lanerjo