Build index type with hundreds properties or many separate types?

(mendy) #1


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

(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:

(system) #3

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