[
https://issues.apache.org/jira/browse/CALCITE-4232?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Shlok Srivastava updated CALCITE-4232:
--------------------------------------
Description:
IN clause is required in multiple queries to fetch documents that contain more
than one *exact terms* in a provided field.
SQL Query
Query -
GET /_search{"query": {"terms":
{"name": [ "kimchy", "elkbee" ],"boost": 1.0}
}}
The above IN query is not supported in calcite elasticsearch adapters.
was:
IN clause is required in multiple queries to fetch documents that contain one
or more **exact terms in a provided field.
Query -
GET /_search{"query": {"terms": {"user.id": [ "kimchy", "elkbee" ],"boost":
1.0}}}
The above IN query is not supported in calcite elasticsearch adapters.
> Elasticsearch IN Query is not supported
> ----------------------------------------
>
> Key: CALCITE-4232
> URL: https://issues.apache.org/jira/browse/CALCITE-4232
> Project: Calcite
> Issue Type: Improvement
> Components: elasticsearch-adapter
> Reporter: Shlok Srivastava
> Priority: Major
> Labels: IN, calcite, elasticsearch, pull-request-available, query
> Time Spent: 1.5h
> Remaining Estimate: 0h
>
> IN clause is required in multiple queries to fetch documents that contain
> more than one *exact terms* in a provided field.
> SQL Query
> Query -
> GET /_search{"query": {"terms":
> {"name": [ "kimchy", "elkbee" ],"boost": 1.0}
> }}
>
> The above IN query is not supported in calcite elasticsearch adapters.
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
