Lucene nested query

Khurram Shehzad <[email protected]> Tue, 10 Apr 2018 08:44:08 +0000

Newsgroups	gmane.comp.jakarta.lucene.user,gmane.text.xml.general
Message-ID	<MWHPR1401MB1887F21E954083C6457D2980EFBE0@MWHPR1401MB1887.namprd14.prod.outlook.com>

--_000_MWHPR1401MB1887F21E954083C6457D2980EFBE0MWHPR1401MB1887_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi guys!


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


For example, find all the employees of the department where one of its empl=
oyee's email address =3D '[email protected]'


SQL would be like:


select * from employee where dept_no in(

select dept_no from employee where email =3D '[email protected]'

)


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

--_000_MWHPR1401MB1887F21E954083C6457D2980EFBE0MWHPR1401MB1887_--