How to use SpanNearQuery in SQL Plugin

[mhsankar]

Hi
i have a query user SpanNearQuery in elasticsearch
how can use SpanNearQuery in SQL Plugin?

[shi-yuan]

Not supported now ! I'll add it soon !

[mhsankar]

thanks @shi-yuan
when do you think add to plugin?

[shi-yuan]

Saturday or Sunday

[shi-yuan]

SELECT * FROM test WHERE q=span_near(boost=10.0,slop=12,in_order=false,clauses='[{"span_term":{"field":"value1"}},{"span_term":{"field":"value2"}},{"span_term":{"field":"value3"}}]')

{
  "from": 0,
  "size": 200,
  "query": {
    "bool": {
      "filter": [
        {
          "bool": {
            "must": [
              {
                "span_near": {
                  "clauses": [
                    {
                      "span_term": {
                        "field": {
                          "value": "value1",
                          "boost": 1
                        }
                      }
                    },
                    {
                      "span_term": {
                        "field": {
                          "value": "value2",
                          "boost": 1
                        }
                      }
                    },
                    {
                      "span_term": {
                        "field": {
                          "value": "value3",
                          "boost": 1
                        }
                      }
                    }
                  ],
                  "slop": 12,
                  "in_order": false,
                  "boost": 10
                }
              }
            ],
            "adjust_pure_negative": true,
            "boost": 1
          }
        }
      ],
      "adjust_pure_negative": true,
      "boost": 1
    }
  }
}