Strings in integer fields?

spazm · August 17, 2016, 11:59pm

I've noticed that if I define a field as type integer I'm allowed to insert values as either strings-of-integers or integers. And when I pull these values back out, they come back in the same form.

I'd like my integers to all be saved as integers, converting as necessary. Is this possible? Am I misunderstanding numeric field types?

For filtering and querying, the integer and string-of-integer values act the same. (good!)
They are not the same for json output. (maybe bad!)
They are not the same in groovy. (e.g. .contains()) (bad!)

In my application, I have a groovy script to do conditional inserts and removals into an array of values in a document, short-circuiting to a no-op (ctx.op="none") if the value is (not) already present -- treating an array of label_ids as a set. This logic gets broken if given a mix of integers and strings-of-integers.

gist.github.com

https://gist.github.com/spazm/efb652831e6fb0f9db4e6640a31e3817

0: create the mapping

curl -XPUT "https://localhost:9200/int_vs_str_test" -d '{"mappings": { "foo" : { "properties": { "label_id": { "type": "integer"}}}}}'

{"acknowledged":true}

1: extract the mapping

curl -XGET "https://127.0.0.1:9200/int_vs_str_test/_mapping/foo?pretty=1"
{
  "int_vs_str_test" : {
    "mappings" : {
      "foo" : {
        "properties" : {
          "label_id" : {
            "type" : "integer"
          }
        }

This file has been truncated. show original

2: insert doc with mixed strings and int

curl -XPUT "https://localhost:9200/int_vs_str_test/foo/1" -d '{"label_id" : [1,"2",3]}'

{"_index":"int_vs_str_test","_type":"foo","_id":"1","_version":1,"_shards":{"total":2,"successful":2,"failed":0},"created"
:true}

There are more than three files. show original

Any pointers would be appreciated.

Thanks,
@spazm

jpountz · August 19, 2016, 9:52am

Maybe you are looking for the coerce option? https://www.elastic.co/guide/en/elasticsearch/reference/current/coerce.html

spazm · August 25, 2016, 5:29am

coerce (default=true) allows quoted numbers to be coerced into numeric fields. But for some reason, ES remembers the original form of string vs numeric, and returns values in their original form.

with coerce=false, the strings would be rejected as invalid.

What I want is a stronger coercion

jpountz · August 31, 2016, 9:41am

Right, elasticsearch does not alter the source document, so this can only be fixed on client side.

Topic		Replies	Views
Saving a value to a field of a different field type e.g. string to integer doesn't throw an exception? Elasticsearch	3	937	March 30, 2017
Strings cooerced to integers are still stored and retrieved as strings Elasticsearch	2	380	July 5, 2017
Indexing string as integer then getting back the integer value in search result Elasticsearch	1	469	September 26, 2017
Text field storing both String & Integer datatypes Elasticsearch painless	1	1256	April 23, 2019
Integer field behaving as string Elasticsearch	3	573	January 19, 2021

Strings in integer fields?

Related topics