lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Erik Hatcher <erik.hatc...@gmail.com>
Subject Re: Solr Query help - sorting
Date Tue, 25 Aug 2009 10:33:42 GMT
You couldn't sort on a multiValued field though.

I'd simply index a max_side field, and have the indexing client add a  
single valued field with max(length,width) to it.  Then sort on  
max_side.

	Erik

On Aug 25, 2009, at 4:00 AM, Constantijn Visinescu wrote:

> make a new multivalued field in your schema.xml, copy both width and  
> length
> into that field, and then sort on that field ?
>
> On Tue, Aug 25, 2009 at 5:40 AM, erikearle@yahoo.com <erikearle@yahoo.com 
> >wrote:
>
>> Clever... but if more than one row adds up to the same value I may  
>> get the
>> wrong order (like 50, 50 and 10, 90)
>>
>> I need a max function but the one provided only compares against a
>> constant.
>>
>> Sent from my iPhone
>>
>> On Aug 24, 2009, at 6:15 PM, Koji Sekiguchi <koji@r.email.ne.jp>  
>> wrote:
>>
>> How about using sum() FunctionQuery, via:
>>
>> http://localhost:8983/solr/select/?q=_val_%3A%22sum%28width%2Clength%29%22
>>
>> Thanks,
>>
>> Koji
>>
>>
>> Erik Earle wrote:
>> Suppose I have a database of rectangle attributes that I have  
>> indexed in
>> Solr and I want to get the top 10 widest or longest rectangles from  
>> one
>> query.
>>
>>
>> name  |  width  |  length
>> A     |  100    |  10
>> B     |  10     |  90
>> C     |  80     |  10
>> ...
>>
>>
>> My indexed fields are:  name, width, length
>>
>> Is there a way to query so that my data returns the order:  A, B, C
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>


Mime
View raw message