Have field with variable type

Elastic Stack Elasticsearch
1

I want to allow these two objects to be indexed:

{ "name": "foo", "value": 12}

{"name": "bar", "value": "twelve"}

where I want to store the object and index on name but not on value.

Is that possible?

2

In the same index?

3

Yes, same index.

The following incantation seems to work. If I index a document with a numeric 'value' property, it seems to retain its number type even though the mapping type is text.

{
    "settings": {
    },
    "mappings": {
        "_default_": {
            "dynamic_templates": [
                {
                    "value_is_any_type": {
                        "match": "value",
                        "mapping": {
                            "type": "text"
                        }
                    }
                },
                {
                    "timestamp": {
                        "match": "timestamp",
                        "mapping": {
                            "type": "date"
                        }
                    }
                }
            ]
        }
    }
}
4

It won't, it will convert it to text because that is the lowest common denominator.

5

Inneresting. I was looking at the record which retains the integer. At least it actually stored the record (rather than rejecting it).

But as you rightly say the index doesn't see that property as integer.

I am avoiding the problem by adjusting my json prop names. The lesson is, I think, use a static type per (nested) prop name.

6

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.