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
Hi Mikhail, 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 means that I've 1.000.000 x 350 (200 + 500 / 2) = 350

Re: Problem with relating values in two multi value fields

2012-10-06 Thread Mikhail Khludnev
Torben, Denormalization implies copying attrs which are common for a group into the smaller docs: 3 value A 200 3 value B 400 3 value B 400 3 value C 240 and use group.facet=true On Sat, Oct 6, 2012 at 2:24 AM, Torben Honigbaum < torben.honigb...@neuland-

Re: Problem with relating values in two multi value fields

2012-10-05 Thread Torben Honigbaum
Hi Mikhail, thank you for your answer. Maybe my sample data was a not so god. The document always have additional data which I need to use as facet like this: 3 value A B ... 200 400 ... Torben Am 05.10.2012 um 17:20 schrieb Mikhail Khludnev: > denor

Re: Problem with relating values in two multi value fields

2012-10-05 Thread Mikhail Khludnev
denormalize your docs to option x value tuples, identify them by duping id. 3 A 200 3 B 400 3 B 400 3 C 240 then collapse them by set "setid" field. (it can not be uniqkey). On Fri, Oct 5, 2012 at 6:26 PM, Torben Honigbaum < torben.honigb...@neuland-bfi.de> wrote:

Re: Problem with relating values in two multi value fields

2012-10-05 Thread Torben Honigbaum
Hi Mikhail, I read the article and can't see how to solve my problem with FieldCollapsing. Any other suggestions? Torben Am 04.10.2012 um 17:31 schrieb Mikhail Khludnev: > it's a typical nested document problem. there are several approaches. Out > of the box solution as far you need facets is

Re: Problem with relating values in two multi value fields

2012-10-04 Thread Mikhail Khludnev
it's a typical nested document problem. there are several approaches. Out of the box solution as far you need facets is http://wiki.apache.org/solr/FieldCollapsing . On Thu, Oct 4, 2012 at 7:19 PM, Torben Honigbaum < torben.honigb...@neuland-bfi.de> wrote: > Hi Jack, > > thank you for your answer

Re: Problem with relating values in two multi value fields

2012-10-04 Thread Torben Honigbaum
Hi Jack, thank you for your answer. The problem is, that I don't know the value for option A and that the values are numbers and I've to use the values as facet. So I need something like this: Docs: 3 A B ... 200 400 ... 4 A E ...

Re: Problem with relating values in two multi value fields

2012-10-04 Thread Jack Krupansky
Use 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 quote it in the query. -- Jack Krupansky -Original Message- From: Torb