Build index type with hundreds properties or many separate types?

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

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

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