Elasticsearch range query for string

Question

The ES index contains a "PRICE" field mapped as a string (due to various reasons): e.g. "2.00" or "245.00"

Running a RANGE FROM/TO (e.g. "5" to "20") query also shows documents with prices such as "500.00", "1515.00" etc.

Does anyone have a functional solution how to circumvent these additional out of range documents from showing up?

The range in your case is a string comparison, while you need floating point comparison. Is there a way you could change the field type? Number stored as string wont help much. Alternatively, you could add another field that holds the actual boolean value? — Srikanth Venugopalan
– Srikanth Venugopalan, Commented Jun 26, 2013 at 9:47
I am trying to avoid changing the field type. But if there is no other way, then yes, it probably can be implemented. — cognito
– cognito, Commented Jun 26, 2013 at 13:10
I understand. Perhaps adding another field of floating point is an option? — Srikanth Venugopalan
– Srikanth Venugopalan, Commented Jun 26, 2013 at 15:23

Duc.Duong · Accepted Answer · 2013-09-20 15:50:21Z

1

You can define a new field like "PRICE_VAL" (or using multi_field "PRICE.val") and explicit map it to "float" or "double" type.

After that, index both the string value and the number value of "PRICE". Now you can do a range query on "PRICE_VAL" without touching the "PRICE" field.

answered Sep 20, 2013 at 15:50

Duc.Duong

2,7902 gold badges25 silver badges29 bronze badges

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

Collectives™ on Stack Overflow

Elasticsearch range query for string

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