lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Geert-Jan Brits <gbr...@gmail.com>
Subject Re: help with a schema design problem
Date Fri, 23 Jul 2010 18:48:39 GMT
With the usecase you specified it should work to just index each "Row" as
you described in your initial post to be a seperate document.
This way p_value and p_type all get singlevalued and you get a correct
combination of p_value and p_type.

However, this may not go so well with other use-cases you have in mind,
e.g.: requiring that no multiple results are returned with the same document
id.



2010/7/23 Pramod Goyal <pramod.goyal@gmail.com>

> I want to do that. But if i understand correctly in solr it would store the
> field like this:
>
> p_value: "Pramod"  "Raj"
> p_type:  "Client" "Supplier"
>
> When i search
> p_value:"Pramod" AND p_type:"Supplier"
>
> it would give me result as document 1. Which is incorrect, since in
> document
> 1 Pramod is a Client and not a Supplier.
>
>
>
>
> On Fri, Jul 23, 2010 at 11:52 PM, Nagelberg, Kallin <
> KNagelberg@globeandmail.com> wrote:
>
> > I think you just want something like:
> >
> > p_value:"Pramod" AND p_type:"Supplier"
> >
> > no?
> > -Kallin Nagelberg
> >
> > -----Original Message-----
> > From: Pramod Goyal [mailto:pramod.goyal@gmail.com]
> > Sent: Friday, July 23, 2010 2:17 PM
> > To: solr-user@lucene.apache.org
> > Subject: help with a schema design problem
> >
> > Hi,
> >
> > Lets say i have table with 3 columns document id Party Value and Party
> > Type.
> > In this table i have 3 rows. 1st row Document id: 1 Party Value: Pramod
> > Party Type: Client. 2nd row: Document id: 1 Party Value: Raj Party Type:
> > Supplier. 3rd row Document id:2 Party Value: Pramod Party Type: Supplier.
> > Now in this table if i use SQL its easy for me find all document with
> Party
> > Value as Pramod and Party Type as Client.
> >
> > I need to design solr schema so that i can do the same in Solr. If i
> create
> > 2 fields in solr schema Party value and Party type both of them multi
> > valued
> > and try to query +Pramod +Supplier then solr will return me the first
> > document, even though in the first document Pramod is a client and not a
> > supplier
> > Thanks,
> > Pramod Goyal
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message