Re: Problem with relating values in two multi value fields

2012-10-08 Thread Mikhail Khludnev
Toke, You are absolutely right, concatenating term is a possible solution. I found faceting is quite complicated in this case, but it was a hot fix which we delivered to production. Torben, This problem arise quite often, beside of these two approaches discussed there, also possible to approach Sp

Re: Problem with relating values in two multi value fields

2012-10-08 Thread Toke Eskildsen
On Mon, 2012-10-08 at 08:42 +0200, Torben Honigbaum wrote: > sorry, my fault. This was one of my first ideas. My problem is, that > I've 1.000.000 documents, each with about 20 attributes. Additionally > each document has between 200 and 500 option-value pairs. So if I > denormalize the data, it me

Re: Problem with relating values in two multi value fields

2012-10-07 Thread Torben Honigbaum
>>>>>> Docs: >>>>>> >>>>>> >>>>>> 3 >>>>>> >>>>>> A >>>>>> B >>>>>> ... >>>>>> >>>>>> >>>>>>

Re: Problem with relating values in two multi value fields

2012-10-06 Thread Mikhail Khludnev
gt;> 400 > >>>> ... > >>>> > >>>> > >>>> > >>>> 4 > >>>> > >>>> A > >>>> E > >>>> ... > >>>> > >>>> > >>>> 300 >

Re: Problem with relating values in two multi value fields

2012-10-05 Thread Torben Honigbaum
gt;>> ... >>>> >>>> >>>> 300 >>>> 400 >>>> ... >>>> >>>> >>>> >>>> 6 >>>> >>>> A >>>> C >>>> ... >>>&

Re: Problem with relating values in two multi value fields

2012-10-05 Thread Mikhail Khludnev
>> > >> > >>200 > >>400 > >>... > >> > >> > >> > >> Query: …?q=options:A > >> > >> Facet: 200 (2), 300 (1) > >> > >> Thank you > >> Torben > >> > >>

Re: Problem with relating values in two multi value fields

2012-10-05 Thread Torben Honigbaum
e a field called "option_value_pairs" with values like "A 200" and >> then query with a quoted phrase "A 200". >>> >>> You could use a special character like equal sign instead of space: >> "A=200" and then you don't have to

Re: Problem with relating values in two multi value fields

2012-10-04 Thread Mikhail Khludnev
se "A 200". > > > > You could use a special character like equal sign instead of space: > "A=200" and then you don't have to quote it in the query. > > > > -- Jack Krupansky > > > > -Original Message- From: Torben Honigbaum > >

Re: Problem with relating values in two multi value fields

2012-10-04 Thread Torben Honigbaum
From: Torben Honigbaum > Sent: Thursday, October 04, 2012 11:03 AM > To: solr-user@lucene.apache.org > Subject: Problem with relating values in two multi value fields > > Hello, > > I've a problem with relating values in two multi value fields. My documents > look like

Re: Problem with relating values in two multi value fields

2012-10-04 Thread Jack Krupansky
k Krupansky -Original Message- From: Torben Honigbaum Sent: Thursday, October 04, 2012 11:03 AM To: solr-user@lucene.apache.org Subject: Problem with relating values in two multi value fields Hello, I've a problem with relating values in two multi value fields. My documents look like t

Problem with relating values in two multi value fields

2012-10-04 Thread Torben Honigbaum
Hello, I've a problem with relating values in two multi value fields. My documents look like this: 3 A B C D 200 400 240 310 My problem is that I've to search for a set of documents and display only the value for option A, for exampl