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.go...@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 < > knagelb...@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.go...@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 > > >