Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-3437

Elasticsearch Match query is not supported

    XMLWordPrintableJSON

    Details

      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.

       

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                shikhasomani20 Shikha Somani
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 3h 50m
                  3h 50m