Range query with elasticsearch for string

Question

I am trying use range query with elasticsearch

{
    "query": {
        "range": {
             "order_no": {
                 "gte": "VM-0001",
                 "lte": "VM-0005"
             }
         }
    }
}

But elastic return no result. I found system have problem with string include - or _

This is mapping of that field:

"order_no" : {
      "type" : "string",
      "index_analyzer" : "str_index_analyzer",
      "search_analyzer" : "str_search_analyzer"
}

{
  "analysis": {
    "analyzer": {
      "str_search_analyzer": {
        "tokenizer": "keyword",
        "filter": [
          "lowercase"
        ]
      },
      "str_index_analyzer": {
        "tokenizer": "keyword",
        "filter": [
          "lowercase",
          "substring"
        ]
      }
    },
    "filter": {
      "substring": {
        "type": "nGram",
        "min_gram": 1,
        "max_gram": 20
      }
    }
  }
}

Andrei Stefan · Accepted Answer · 2014-11-26 08:34:35Z

5

As per the documentation, in case of string fields, Elasticsearch uses a TermRangeQuery which as far as I know doesn't analyze the term to search for. This means that your range VM-0001 - VM-0005 searches for exact these terms. Whereas you have in your index something like vm-0001 (lowercase). So, either use:

{
  "query": {
    "range": {
      "order_no": {
        "gte": "vm-0001",
        "lte": "vm-0005"
      }
    }
  }
}

or add another field in your index where you keep the order_no as keyword without any lowercasing or nGram-atization.

answered Nov 26, 2014 at 8:34

Andrei Stefan

52.5k6 gold badges102 silver badges92 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

hoangvu68 Over a year ago

:) Thanks you so much. I did it success.

Tuân Nguyễn · Accepted Answer · 2014-12-01 07:24:28Z

4

{
  "query": {
    "range": {
      "order_no": {
        "gte": "vm-0001",
        "lte": "vm-0005"
      }
    }
  }
}

answered Dec 1, 2014 at 7:24

Tuân Nguyễn

642 bronze badges

Collectives™ on Stack Overflow

Range query with elasticsearch for string

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related