Re: Linking of query/search

2014-09-12 Thread matej . zerovnik
Hello! Can anyone shine some light on my question? Is the query in question achievable in ES directly? If not, I can probably do that in application later, but it would be nicer if ES could serve me the final results. Matej -- You received this message because you are subscribed to the

Re: Linking of query/search

2014-09-12 Thread Ivan Brusic
You cannot join documents in Lucene/Elasticsearch (at least not like a RDBMS). You would need to either denormalize your data, join on the client side or execute 2+ queries. -- Ivan On Fri, Sep 12, 2014 at 12:45 AM, matej.zerov...@gmail.com wrote: Hello! Can anyone shine some light on my

Re: Linking of query/search

2014-09-12 Thread Alex Kamil
you can combine ES with RDBMS, and run your SQL queries either directly against db, or pull data via JDBC River into ES, I wrote about it here: http://lessc0de.github.io/connecting_hbase_to_elasticsearch.html On Fri, Sep 12, 2014 at 10:55 AM, Ivan Brusic i...@brusic.com wrote: You cannot join

Linking of query/search

2014-09-09 Thread matej . zerovnik
I'm currently evaluating using ES and logstash as a central log management. Aside from storing logs in ES, I will need to do some querying and reports as well. This is where I get into troubles, because I'm not sure how to solve the following problem. I have a service, where a certain user