Elasticsearch java.lang.NumberFormatExcepion when requesting on string and number fields

Question

I am trying to implement a search request in an app with ElasticSearch.

The user type some words and those words are sent to Elastic in a json request.

To be simple the my request example is like this :

body: {
  'query': {
        'multi_match': {
            'query': 'nameValue idValue',
            'type': 'most_fields',
            'fields': ['name','id'],
        }
    },}

I get the following error :

Caused by: java.lang.NumberFormatException: For input string: "nameValue"

I understand why I get this error. It's because I am trying to search a string in a number field : id. But I would like to be able to request on a string and number at the same time.

I would also like to avoid to split the words and try to determine which word is a number and which one is a string prior to send to Elastic Search.

I tried to change my request without success.

I could change the mapping of id but it'S a number so I try to avoid this solution.

You can try to add lenient: true to your query to ignore such data-type errors. — Val
– Val, Commented Aug 6, 2018 at 16:08
@val do you want to add your answer in order for me to close this post? — Xavier Bouclet
– Xavier Bouclet, Commented Aug 15, 2018 at 15:27

Val · Accepted Answer · 2018-08-16 03:34:27Z

2

You can try to add lenient: true to your query to ignore such data-type errors.

body: {
  'query': {
        'multi_match': {
            'query': 'nameValue idValue',
            'type': 'most_fields',
            'fields': ['name','id'],
            'lenient': true                  <--- add this
        }
    },}

answered Aug 16, 2018 at 3:34

Val

218k14 gold badges377 silver badges384 bronze badges

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

Collectives™ on Stack Overflow

Elasticsearch java.lang.NumberFormatExcepion when requesting on string and number fields

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