Numberformat exception

prateek · January 23, 2015, 6:54pm

I am indexing different type of fields that include number and strings.
When I use multimatch queries (that includes both number and string fields)
for terms such as "2001 camaro", I get NumberFormatException. I understand
why this is happening but wondering if this can be avoided. Temporarily, I
have fixed it by indexing all fields as strings instead of numbers.

Example:
Fields used : year (number) and model (string)
multimatch cross type query includes both year and model.
search query: 2001 camaro

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/97149488-9e49-4ba8-8bdb-1a1a157e79b1%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

jprante · January 23, 2015, 8:23pm

On this issue is being worked on

github.com/elastic/elasticsearch

multi_match query crashes with NumberFormatException

opened 01:38PM - 25 Oct 13 UTC

closed 10:06AM - 27 Mar 15 UTC

eltu

discuss

When execute this simple example it crashes: ``` curl -XPUT http://localhost:92…00/blog/post/1?pretty=1 -d '{"foo":123, "bar":"xyzzy"}' curl -XGET http://localhost:9200/blog/post/_search?pretty=1 -d '{"query": {"multi_match": {"fields": ["foo", "bar"], "query": "xyzzy", "useDisMax": true}}}' ``` stack trace: { "error" : "SearchPhaseExecutionException[Failed to execute phase [query], all shards failed; shardFailures {[BIXGo8_wTEiO9jVc0KjZ_w][blog][1]: SearchParseException[[blog][1]: from[-1],size[-1]: Parse Failure [Failed to parse source [{\"query\": {\"multi_match\": {\"fields\": [\"foo\", \"bar\"], \"query\": \"xyzzy\", \"useDisMax\": true}}}]]]; nested: NumberFormatException[For input string: \"xyzzy\"]; }{[BIXGo8_wTEiO9jVc0KjZ_w][blog][0]: SearchParseException[[blog][0]: from[-1],size[-1]: Parse Failure [Failed to parse source [{\"query\": {\"multi_match\": {\"fields\": [\"foo\", \"bar\"], \"query\": \"xyzzy\", \"useDisMax\": true}}}]]]; nested: NumberFormatException[For input string: \"xyzzy\"]; }{[BIXGo8_wTEiO9jVc0KjZ_w][blog][4]: SearchParseException[[blog][4]: from[-1],size[-1]: Parse Failure [Failed to parse source [{\"query\": {\"multi_match\": {\"fields\": [\"foo\", \"bar\"], \"query\": \"xyzzy\", \"useDisMax\": true}}}]]]; nested: NumberFormatException[For input string: \"xyzzy\"]; }{[BIXGo8_wTEiO9jVc0KjZ_w][blog][2]: SearchParseException[[blog][2]: from[-1],size[-1]: Parse Failure [Failed to parse source [{\"query\": {\"multi_match\": {\"fields\": [\"foo\", \"bar\"], \"query\": \"xyzzy\", \"useDisMax\": true}}}]]]; nested: NumberFormatException[For input string: \"xyzzy\"]; }{[BIXGo8_wTEiO9jVc0KjZ_w][blog][3]: SearchParseException[[blog][3]: from[-1],size[-1]: Parse Failure [Failed to parse source [{\"query\": {\"multi_match\": {\"fields\": [\"foo\", \"bar\"], \"query\": \"xyzzy\", \"useDisMax\": true}}}]]]; nested: NumberFormatException[For input string: \"xyzzy\"]; }]", "status" : 400 }

Indexing all fields as strings seems like a plausible workaround.

Jörg

On Fri, Jan 23, 2015 at 7:54 PM, Prateek Asthana paryanz@gmail.com wrote:

I am indexing different type of fields that include number and strings.
When I use multimatch queries (that includes both number and string fields)
for terms such as "2001 camaro", I get NumberFormatException. I understand
why this is happening but wondering if this can be avoided. Temporarily, I
have fixed it by indexing all fields as strings instead of numbers.

Example:
Fields used : year (number) and model (string)
multimatch cross type query includes both year and model.
search query: 2001 camaro

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/97149488-9e49-4ba8-8bdb-1a1a157e79b1%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/97149488-9e49-4ba8-8bdb-1a1a157e79b1%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAKdsXoHUkoL9GaoCu1g6Fv-UbLj-LWydTxvTFgWgurQA%3Dc7adA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.