[CALCITE-4270] Elasticsearch Collapse Query is not supported

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: elasticsearch-adapter
• Labels: QueryBuilder calcite collapse elasticsearch
• Assignee: Unassigned
• Reporter: Shlok Srivastava
• Created: 21/Sep/20 07:29
• Updated: 24/Sep/20 08:02

Description

Allows to collapse search results based on field values. The collapsing is done by selecting only the top sorted document per collapse key. This can be used while querying on multi-indices and get top sorted results.

Query for collapse - 
{"query": {"match": {"message": "elasticsearch"}},"collapse" : {"field" : "user"
}}
 

Currently we can query on multiple indices via calcite but collapse is not supported - https://www.elastic.co/guide/en/elasticsearch/reference/6.8/search-request-collapse.html