Build index type with hundreds properties or many separate types?


(mendy) #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


(David Pilato) #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


(system) #3

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