lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bharani <>
Subject Multiple Values -Structured?
Date Mon, 03 Sep 2007 04:53:41 GMT


I have got two sets of document

1) Primary Document
2) Occurrences of primary document

Since there is no such thing as "join" i can either 

a) Post the primary document with occurrences as multi valued field
b) Post the primary document for every occurrences i.e. classic
de-normalized route

My problem with 

Option a) This works great as long as the occurrence is a single field but
if i had a group of fields that describes the occurrence then the search
returns wrong results becuase of the nature of text search

i.e <date>1 Jan 2007</date>
<type> review</type>

<date> 2 Jan 2007 </date>
<type> revision</type>

if i search for 2 Jan 2007 and <date> 1 Jan 2007 </date> i will get a hit
(which is wrong)  becuase there is no grouping of fields to associate date
and type as one unit. If i merge them as one entity then i cant use the
range quieries for date

Option B) This would result in large number of documents and even if i try
with index only and not store i am still have to deal with duplicate hit -
becuase all i want is the primary document

Is there a better approach to the problem?


View this message in context:
Sent from the Solr - User mailing list archive at

View raw message