[CALCITE-4233] Elasticsearch Dismax API is not supported in calcite

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.27.0
• Component/s: elasticsearch-adapter
• Labels: QueryBuilder calcite dismax elasticsearch pull-request-available
• Assignee: Unassigned
• Reporter: Shlok Srivastava
• Created: 06/Sep/20 10:35
• Updated: 03/Jun/21 22:31
• Resolved: 02/Nov/20 07:36

Description

Currently, Calcite use constant_score API to build all the queries. which do not boost the documents based on relevance score from any matching clause which is supported by disMax API. It does not support dismax query builders - https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-dis-max-query.html.

 

Dismax query -

GET /_search
{
  "query": {
    "dis_max": {
      "queries": [
        {
          "bool": {
            "should": [
              {
                "term": {
                  "Name": "James"
                }
              },
              {
                "term": {
                  "Name": "Peter"
                }
              },
              {
                "term": {
                  "Name": "Harry"
                }
              },
              
            }
          ]
        }
      ]
    }
  }

Suggested solution  - Queries with OR conditions should use disMax builders to fetch the best matching documents.
 

Sample SQL query - 

WHERE Name="James" OR Name="Peter" OR Name="Harry" 

Sample RelNode - 

relB.or(relB.equals(relb.literal("Name"),relb.literal"James"),
relB.equals(relb.literal("Name"),relb.literal"Peter"),
relB.equals(relb.literal("Name"),relb.literal"Harry")

Issue Links

• links to: GitHub Pull Request #2218