Can we search from multiple indexs and assemble their?

can we search from multiple indexs and assemble their?

eg:
there are two index person and car,
there are a field called sex in index person and a field called color in index car,we want to search the women who own black cars in one request。
how can we make it?

That would require a join across indices which Elasticsearch does not support. You therefore probably need to restructure how you store data, e.g. by denormalizing.

1 Like