How can I use Solr subquery similar to rdbms subqueries?

solr subquery solr-query-syntax
Nazanin picture Nazanin · May 28, 2015 · Viewed 7k times · Source

I need to run a query in Solr that contains another query as terms of the main query!

Something like this in the RDBMS SQL: 

select name from movie
where movie.writer in (
    select director from movie where producer = 'XXX'
)

Is there any way to do this is Solr?

Answer

Abhijit Bashetti picture Abhijit Bashetti · May 28, 2015

you can try filter, something like this..

q=movie:name
fq=(writer:writer_name AND producer:Producer_name)

also the data that you put into a Solr index is flat or denormalized. So take the suquery field values and put them in an AND part of the query to Solr. 

q=(movie:name AND writer:Writer_name AND producer:Producer_name)

Related questions

Solr vs. ElasticSearch

What are the core architectural differences between these technologies? Also, what use cases are generally more appropriate for each?

Read More
ElasticSearch, Sphinx, Lucene, Solr, Xapian. Which fits for which usage?

I'm currently looking at other search methods rather than having a huge SQL query. I saw elasticsearch recently and played with whoosh (a Python implementation of a search engine). Can you give reasons for your choice(s)?

Read More
How to delete all data from solr and hbase

How do I delete all data from solr by command? We are using solr with lily and hbase. How can I delete data from both hbase and solr? http://lucene.apache.org/solr/4_10_0/tutorial.html#Deleting+Data

Read More