Hi Erick,
Why not combine the indexes? That would be the "lucene way"...
I combined them by joining tables but it gets very very large and ResaltSet failed to retrieve the fields!!! On 3/26/07, Erick Erickson <[EMAIL PROTECTED]> wrote:
The short form is no. Lucene is emphatically NOT a relational database. Of course, you could take the results of the first search, collect the IDs and query the second, but for large sets this may not be practical Why not combine the indexes? That would be the "lucene way"... There has been extensive discussion of embedding Lucene in a DB, but I can't remember who. Search the archive for Oracle and you'll find an extensive discussion.... Best Erick On 3/26/07, Mohammad Norouzi <[EMAIL PROTECTED]> wrote: > > I mean when I get result from the first index, find the common records > from > the second index depending on first result. > something like relation between two database tables, relation by primary > key > > index1: > id name somefield1 > 1 jack value1 > 2 Michael value2 > 3 Sara value3 > 4 Joseph value4 > ... > > > index2: > id field1 field2 field3 > 2 fval1-1 fval2-1 fval3-1 > 4 fval1-2 fval2-2 fval3-2 > ... > > now a user puts query : name:Michael > > I should return the result wrapped in following document: > document: > id name somefield1 field1 field2 field3 > > ------------------------------------------------------------------------------------------ > 2 Michael value2 fval1-1 fval2-1 > fval3-1 > > > > On 3/26/07, jafarim <[EMAIL PROTECTED]> wrote: > > > > what do you mean by "applying the result to the second one"? > > > > On 3/26/07, Mohammad Norouzi <[EMAIL PROTECTED]> wrote: > > > > > > hi > > > I have two separated index but there are some fields that are common > > > between > > > them. now I want to search from one index and then apply the result to > > the > > > second one. what solution do you suggest? > > > what happens on fields? I mean the first document has some fields that > > are > > > not present in the second one so I need the final document has all the > > > fields of both indexes. > > > > > > thanks > > > > > > > > > -- > > > Regards, > > > Mohammad > > > > > > > > > -- > Regards, > Mohammad >
-- Regards, Mohammad
