OK I'm sorry if I did not explained well my need. I'll try to give a
better explanation.
What I have : Millions of documents that have a field X , another field
Y and another field Z which is not required (So it can be empty in some
documents and not in others).
What I want to do : Search for docs that have the field X equals
something and group them by field Z (so that only 1 document is returned
for every field Z value), BUT I want documents who have field Z as empty
to be included in the results (all of them), and sort the results by
field Y (so I can't separate the request into two requests).
I hope that this is clearer.
On 02/22/2013 03:59 PM, Jack Krupansky wrote:
What?!?! You want them grouped but not grouped together?? What on
earth does that mean?! I mean, either they are included or they are
not. All results will be in some group, so where exactly do you want
these "not to be grouped together" documents to be grouped? In any
case, please clarify what your expectations really are.
-- Jack Krupansky
-----Original Message----- From: Oussama Jilal
Sent: Friday, February 22, 2013 7:17 AM
To: solr-user@lucene.apache.org
Subject: Re: Solr Grouping and empty fields
Thank you Johannes, but I want the documents having the field empty to
be included in the results, just not to be grouped together, and if I
understood your solution correctly, it will simply remove those
documents from the results (Note : The field values are very variable
and unknown to me).
On 02/22/2013 02:53 PM, Johannes Rodenwald wrote:
Hi Oussama,
If you have only a few distinct, unchanging values in the field that
you group upon, you could implement a FilterQuery (query parameter
"fq") and add it to the query, allowing all valid values, but not an
empty field. For example:
fq=my_grouping_string_field:( value_a OR value_b OR value_c OR value_d )
If you use SOLR 4.x, you should be able to group upon an integer
field, allowing a range filter:
(I still work with 3.6 which can only group on string fields, so i
didnt test this one)
fq=my_grouping_integer_field:[1 TO *]
--
Johannes Rodenwald
----- Ursprüngliche Mail -----
Von: "Oussama Jilal" <jilal.ouss...@gmail.com>
An: solr-user@lucene.apache.org
Gesendet: Freitag, 22. Februar 2013 12:32:13
Betreff: Solr Grouping and empty fields
Hi,
I need to group some results in solr based on a field, but I don't want
documents having that field empty to be grouped together, does anyone
know how to achieve that ?
--
Oussama Jilal
