elasticsearch - querying multiple indexes is possible?

Question

I have an elasticsearch cluster with 3 indexes:

/users/user
/events/visit
/events/register
/pages/page

So, now I need to run queries processing multiple indexes.

Eg: Get gender of users registered in page X. (To get this info, I need infos from multiple indexes.)

Is this possible? Maybe integrating hadoop?

Answer 1

This is quite easy within Elasticsearch itself! Anytime you would specify an index, you can separate additional indices by comma.

curl -XGET 'http://localhost:9200/index1,index2/_search?q=yourQueryHere'

You can also search all indices with _all.

curl -XGET 'http://localhost:9200/_all/_search?q=yourQueryHere'

Here's some helpful documentation from elasticsearch's website. This site has TONS of info, but it is a bit difficult to find sometimes, IMO.

https://www.elastic.co/guide/en/elasticsearch/reference/current/search-search.html https://www.elastic.co/guide/en/elasticsearch/reference/current/multi-index.html