lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marc Sturlese <marc.sturl...@gmail.com>
Subject Re: Optimizing a query to sort results alphabetically for a determinated field
Date Mon, 24 Aug 2009 12:10:22 GMT

It just worked. Thanks a lot! Good to know sortMissingLast works not just in
sortable fields

Constantijn Visinescu wrote:
> 
> not 100% sure  but the example schema has:
>     <fieldType name="string" class="solr.StrField" sortMissingLast="true"
> omitNorms="true"/>
> 
> So i'd say give it a go and see what happens ;)
> 
> On Mon, Aug 24, 2009 at 12:24 PM, Marc Sturlese
> <marc.sturlese@gmail.com>wrote:
> 
>>
>> Yes but I thought it was just for sortable fields:
>> sint,sfloat,sdouble,slong.
>> Can I apply "sortMissingLast"to  text fields analyzed with
>> KeywordAnalyzer?
>>
>> Constantijn Visinescu wrote:
>> >
>> > There's a "sortMissingLast" true/false property that you can set on
>> your
>> > fielType definitions in the schema.
>> >
>> > On Mon, Aug 24, 2009 at 11:58 AM, Marc Sturlese
>> > <marc.sturlese@gmail.com>wrote:
>> >
>> >>
>> >> Hey there, I need to sort my query results alphabetically for a
>> >> determinated
>> >> field called "town". This field is analyzed with a KeywordAnalyzer and
>> >> isn't
>> >> multiValued. Add that some docs doesn't doesn'h have this field.
>> >> Doing just:
>> >>
>> >>
>> >>
>> http://localhost/solr//select/?q=whatever&version=2.2&start=0&rows=10&indent=on&sort=town
>> >> asc
>> >>
>> >> Will give me back the results sorted alphabetically but will put the
>> docs
>> >> that doesn't have this field (town) at the begining.
>> >> I want them at the end or I want them not to apear. This query solves
>> the
>> >> problem:
>> >>
>> >>
>> >>
>> http://localhost/solr//select/?q=whatever&version=2.2&start=0&rows=10&indent=on&sort=town
>> >> asc&fq=town:[a<
>> http://localhost/solr//select/?q=whatever&version=2.2&start=0&rows=10&indent=on&sort=town%0Aasc&fq=town:%5Ba
>> >TO
>> >> z]
>> >>
>> >> But applying this filter: fq=town:[a TO z] is definitely not good in
>> >> terms
>> >> of memory, speed and clauses...
>> >> Is there any way to do something similar but with a more optimized
>> query?
>> >> Thanks in advance!
>> >>
>> >> --
>> >> View this message in context:
>> >>
>> http://www.nabble.com/Optimizing-a-query-to-sort-results-alphabetically-for-a-determinated-field-tp25113379p25113379.html
>> >> Sent from the Solr - User mailing list archive at Nabble.com.
>> >>
>> >>
>> >
>> >
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Optimizing-a-query-to-sort-results-alphabetically-for-a-determinated-field-tp25113379p25113637.html
>> Sent from the Solr - User mailing list archive at Nabble.com.
>>
>>
> 
> 

-- 
View this message in context: http://www.nabble.com/Optimizing-a-query-to-sort-results-alphabetically-for-a-determinated-field-tp25113379p25114941.html
Sent from the Solr - User mailing list archive at Nabble.com.


Mime
View raw message