Build index type with hundreds properties or many separate types?

Elastic Stack Elasticsearch
1

Hello,

I need your advice in setting up an index in elastic.
Under the index I need to keep Tens of millions of documents. underneath one of the fields have many properties and some fields exist in all documents type (and I also have to allow to perform a joint search).

Is it better to build one type with more than a thousand nested properties or to do for each type of document (maybe more then 500) own type of itself?

Thank you
Mandy

2

You can't do "join" in elasticsearch. You have something similar with parent/child feature though but use it only if it's absolutely needed. Otherwise duplicating information is fine in most cases.

Note that from 5.0 you have some default limits now: https://www.elastic.co/guide/en/elasticsearch/reference/current/breaking_50_mapping_changes.html#_field_mapping_limits

1 Like
3

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