[ 
https://issues.apache.org/jira/browse/CALCITE-3437?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Shikha Somani updated CALCITE-3437:
-----------------------------------
    Description: 
Currently, Calcite only builds "text" queries on elasticsearch for text fields. 
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:
{code:java}
{
  "query": {
    "constant_score": {
      "filter": {
        "match": {
          "name": "Customer Name"
        }
      }
    }
  }
}
{code}
 

Expected behavior:

For SqlStdOperatorTable.CONTAINS, calcite should build _match_ query.

 

  was:
Currently, Calcite only builds "text" queries on elasticsearch for text fields. 
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:
{code:java}
{
  "query": {
    "constant_score": {
      "filter": {
        "match": {
          "name": "Customer Name"
        }
      }
    }
  }
}
{code}
 

Expected behavior:

For SqlStdOperatorTable.CONTAINS, calcite should build _match_ query.

 


> Elasticsearch Match query is not supported
> ------------------------------------------
>
>                 Key: CALCITE-3437
>                 URL: https://issues.apache.org/jira/browse/CALCITE-3437
>             Project: Calcite
>          Issue Type: Improvement
>          Components: elasticsearch-adapter
>            Reporter: Shikha Somani
>            Priority: Major
>
> Currently, Calcite only builds "text" queries on elasticsearch for text 
> fields. 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:
> {code:java}
> {
>   "query": {
>     "constant_score": {
>       "filter": {
>         "match": {
>           "name": "Customer Name"
>         }
>       }
>     }
>   }
> }
> {code}
>  
> Expected behavior:
> For SqlStdOperatorTable.CONTAINS, calcite should build _match_ query.
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to