elasticsearch range filter incorrect

Question

Everyone. This is a simple test code with the elasitcsearch document url

curl -XPOST 'localhost:9200/customer/external/_search?pretty'

{ "took" : 3, "timed_out" : false, "_shards" : { "total" : 5, "successful" : 5, "failed" : 0 }, "hits" : { "total" : 2, "max_score" : 1.0, "hits" : [ { "_index" : "customer", "_type" : "external", "_id" : "1", "_score" : 1.0, "_source":{"age":20,"balance":100000,"name":"Thomas.St.Wang"} }, { "_index" : "customer", "_type" : "external", "_id" : "2", "_score" : 1.0, "_source":{"age":19,"balance":10000,"name":"T.S.W"} } ] } }

The following request is not the result i expect. Why.

 curl -XPOST 'localhost:9200/customer/external/_search?pretty' -d 



{  
   "query":{  
      "filtered":{  
         "query":{  
            "match_all":{  

            }
         },
         "filter":{  
            "range":{  
               "balance":{  
                  "gte":9999,
                  "lte":100001
               }
            }
         }
      }
   }
}

{ "took" : 2, "timed_out" : false, "_shards" : { "total" : 5, "successful" : 5, "failed" : 0 }, "hits" : { "total" : 0, "max_score" : null, "hits" : [ ] } }

What's wrong with my query? Thanks.

hello_god · Accepted Answer · 2017-03-22 03:06:59Z

0

 curl -XGET 'localhost:9200/customer/_mapping/external/field/balance'

{"customer":{"mappings":{"external":{"balance":{"full_name":"balance","mapping":{"balance":{"type":"string"}}}}}}}

This is the answer. Because the balance filed is a string. I need delete the index,and restart index it.

edited Mar 22, 2017 at 3:06

answered Mar 22, 2017 at 2:43

hello_god

17311 bronze badges

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

Collectives™ on Stack Overflow

elasticsearch range filter incorrect

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest