[CALCITE-3437] Elasticsearch Match query is not supported

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.22.0
• Component/s: elasticsearch-adapter
• Labels: QueryBuilder calcite elasticsearch match pull-request-available
• Assignee: Unassigned
• Reporter: Shikha Somani
• Created: 22/Oct/19 14:19
• Updated: 19/Feb/24 07:34
• Resolved: 08/Nov/19 17:37

Description

Currently, Calcite only builds "term" queries for text fields on elasticsearch. It doesn't support [Match|https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-match-query.html] queries due to which full-text or contains search is not allowed.

Expected query:

{
  "query": {
    "constant_score": {
      "filter": {
        "match": {
          "name": "Customer Name"
        }
      }
    }
  }
}

 

Expected behavior:

For SqlStdOperatorTable.CONTAINS, calcite should build match query.

 

Issue Links

• links to: GitHub Pull Request #1530