On Fri, Jan 18, 2013 at 9:05 PM, Apostolis Xekoukoulotakis <
xekou...@gmail.com> wrote:
> 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.
>
> Thank you Apostolis,
That is definitely giving me some headstarts. Will check with
this and also update this thread, when I infer.
>
>
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
>
