ElasticSearch: Search across multiple fields with input strings (NumberFormatException)

Question

I am searching across multiple fields in a query using the * asterisk notation (Ex: I want all fields startings with source so I specify fields source.*) and I specify a query of foobar as string. I am using a Query String type query.

I keep getting a NumberFormatException and I have some fields in there with a mapping type of long and double.

Any idea how to go about this? I need to do a multi-field search.

My query is posted below:

{
    "query": {
        "bool": {
            "must": [{
                "query_string": {
                    "default_field": "source.*",
                    "query": "foobar"
                }
            }],
            "must_not": [],
            "should": []
        }
    },
    "from": 0,
    "size": 100000,
    "sort": [],
    "facets": {}
}

And you were expecting not to get an exception when trying to compare a string to a numeric field? — bittusarkar
– bittusarkar, Commented Jul 23, 2015 at 20:23
@bittusarkar I was hoping if there was a work around. I was expecting to get the exception. — user1757703
– user1757703, Commented Jul 23, 2015 at 20:25

keety · Accepted Answer · 2015-07-23 20:25:40Z

7

set lenient to true to ignore format based failures

example :

"query_string": 
 {
      "default_field": "source.*",
      "query": "foobar",
      "lenient": true

 }

answered Jul 23, 2015 at 20:25

keety

17.5k4 gold badges53 silver badges58 bronze badges

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

Collectives™ on Stack Overflow

ElasticSearch: Search across multiple fields with input strings (NumberFormatException)

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

Related