Join like querys


(Roi Rodríguez Sánchez) #1

Hello,

We are plannig to use ElasticSearch as a unified index and data storage
solution, by now we use Apache Solr and MySQL. We have recently read that
Solr4 will bring the capability to make "join" querys
(http://wiki.apache.org/solr/Join, in fact is more like an inner query).

So, knowing that Solr and ElasticSearch are both based in Lucene... is that
feature currently suported in ElasticSearch Query Language or is planned to
be that feature in future releases of ElasticSearch?

Please excuse me, if I'm asking nosense... We have searched in the docs,
but I think nested querys doesn't match our needs, as we have to make the
query into two separated index.

Thanks in advance :slight_smile:


(Shay Banon) #2

There is something similar, either using parent / child support (has_child filter, with parent mapping), or using nested docs. Note, join is only supported within a shard, so we need to make sure the data exists within the same shard (parent child case, the child is placed in the same shard as the parent).

On Friday, February 10, 2012 at 6:13 PM, Roi Rodríguez Sánchez wrote:

Hello,

We are plannig to use ElasticSearch as a unified index and data storage solution, by now we use Apache Solr and MySQL. We have recently read that Solr4 will bring the capability to make "join" querys (http://wiki.apache.org/solr/Join, in fact is more like an inner query).

So, knowing that Solr and ElasticSearch are both based in Lucene... is that feature currently suported in ElasticSearch Query Language or is planned to be that feature in future releases of ElasticSearch?

Please excuse me, if I'm asking nosense... We have searched in the docs, but I think nested querys doesn't match our needs, as we have to make the query into two separated index.

Thanks in advance :slight_smile:


(Roi Rodríguez Sánchez) #3

Thank you... we will test if with this restrictions we can implement those
capabilities.


(system) #4