You can put those fields as a DocValue type of field. They are optimized
for use during search(or join in this case).

Then create a collector that collects the documents which have the same
value in those fields.

Have other more experienced comment though before you start implementing it.


2013/1/18 Ramprakash Ramamoorthy <r4ramprak...@gmail.com>

> Dear all,
>
>          I know, lucene is no relational database, but spare me. I need to
> run a search across an index, and find fields that have a common equal
> value, where the common value is unknown(to be determined at run time).
>
>          An outright sql query would be *SELECT * from table1 where
> table1.field1=table2.field3=table3.field2; *
>
> *        *How do I proceed upon this? Get distinct values (if at all it is
> possible) for a field and iterate the query across fields is the only
> solution? Or is there an aesthetic way?
>
>          Please to help. Thanks in advance.
>
> --
> With thanks and regards,
> Ramprakash Ramamoorthy,
> SASTRA University,
> India.
>



-- 


Sincerely yours,

     Apostolis Xekoukoulotakis

Reply via email to