lucene-general mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Khurram Shehzad <khurram_sheh...@live.com>
Subject Lucene nested query
Date Tue, 10 Apr 2018 08:44:08 GMT
Hi guys!


I've a scenario where the lucene query depends on the result of another lucene query.


For example, find all the employees of the department where one of its employee's email address
= 'abc@email.com'


SQL would be like:


select * from employee where dept_no in(

select dept_no from employee where email = 'abc@email.com'

)


Please note that employee is a huge data and inner query can result into 5 million rows


Any thoughts how to replicate this scenario using core lucene?


Regards,

Khurram

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message