Range with elasticsearch

Question

I am trying search with elasticsearch with range query. (PHP)

This is my source code

$searchParams['body']['query']['range']['order_no']['gte'] = "2000";
$searchParams['body']['query']['range']['order_no']['lte'] = "2001";

=

{
    "query": {
        "range": {
             "order_no": {
                 "gte": 2000,
                 "lte": 2001
             }
         }
    }
}

But in result it have order_no:

I want show only

2000
2001

This field have mapping:

"order_no" : {
    "type" : "string",
     "index" : "not_analyzed"
}

How can fix it?

Saeed Zhiany · Accepted Answer · 2016-12-14 08:40:37Z

3

The best and most effective way is to change your field mapping to

{
  "order_no": {
    "type": "integer",
    "index": "not_analyzed"
  }
}

String range queries are very slow compared to numeric range ones.

If you are constrained from changing the field mapping then another option is to pad the input values with zeros while indexing as well as searching as

{
  "query": {
    "range": {
      "order_no": {
        "gte": 00002000,
        "lte": 00002001
      }
    }
  }
}

edited Dec 14, 2016 at 8:40

Saeed Zhiany

2,1419 gold badges34 silver badges44 bronze badges

answered Nov 26, 2014 at 5:28

Prabin Meitei

2,0001 gold badge13 silver badges16 bronze badges

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

3 Comments

hoangvu68 Over a year ago

Hi. I have another question if you can help me. I can't use range query with string have "-" or "_". Do you know the reason?

hoangvu68 Over a year ago

stackoverflow.com/questions/27144102/… :)

sox supports the mods Over a year ago

What's the explanation for this behavior? is there any source in the docs?

Collectives™ on Stack Overflow

Range with elasticsearch

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related