That would depend on your indexing setup. We have a custom application for indexing, so we just make a value up. In our case a GUID (UUID). But I imagine that you could also just copy your id field with a prefix. It depends on your data and tools. Teun Op 24 feb. 2013 15:00 schreef "Jilal Oussama" <jilal.ouss...@gmail.com> het volgende:
> Oh this is a good one ! Thank you very much Teun (But I will have to ask > you how do you generate a unique value for the copy field when the original > one is empty? Do you do this manualy or solr can do it?) > And thanks again. > On Feb 24, 2013 12:11 PM, "Teun Duynstee" <t...@duynstee.com> wrote: > > > We had a comparable situation. We created an extra field and at index > time > > copy the value if there is one and create a unique dummy value if there > is > > none. We couldn't just make the initial field required, because it has a > > meaning other than just a grouping key. > > Teun > > Op 22 feb. 2013 20:47 schreef "Daniel Collins" <danwcoll...@gmail.com> > het > > volgende: > > > > > We had something similar to be fair, a cluster information field which > > was > > > unfortunately optional, so all the documents that didn't have this > field > > > set grouped together. > > > > > > It isn't Solr's fault, to be fair, we told it to group on the values of > > > field Z, null is a valid value and lots of documents have that value so > > > they all group together. We got what we asked for :-) > > > > > > Our solution was to make that field mandatory, and in our indexing > > > pipeline we will set that field to some unique value (same as the > > document > > > key if necessary) if it isn't set already to ensure that every document > > has > > > that field set appropriately. > > > > > > -----Original Message----- From: Oussama Jilal > > > Sent: Friday, February 22, 2013 5:25 PM > > > To: solr-user@lucene.apache.org > > > Subject: Re: Solr Grouping and empty fields > > > > > > 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 > > > > > > > > >
