When querying several indices, is there a way to get "unique" hits? By
"unique" I mean based on entity+id equality.
Say I have several CSV files that may contain data on common entities but
have varying columns and I've indexed them in separate indices in ES (using
the same "entity type" in all indices). The result is several indices where
some contain the same entity+id document. Can I ask ES to search through all
indices and return unique documents (entity+id)? I guess it's similar to an
SQL join where you query several tables and specify how you join them (in
this case, the join would always happen on "_id").
I know putting everything in one index would solve my problem, but for the
sake of management, it's simpler for me to manage several indices (one per
CSV so to speak).
I this a valid feature for ES? Is there a way to do this already?