You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by Scott K <so...@skister.com> on 2010/08/30 23:04:28 UTC
Distance sorting with spatial filtering
The new spatial filtering (SOLR-1586) works great and is much faster
than fq={!frange. However, I am having problems sorting by distance.
If I try
GET 'http://localhost:8983/solr/select/?q=*:*&sort=dist(2,latitude,longitude,0,0)+asc'
I get an error:
Error 400 can not sort on unindexed field: dist(2,latitude,longitude,0,0)
I was able to work around this with
GET 'http://localhost:8983/solr/select/?q=*:* AND _val_:"recip(dist(2,
latitude, longitude, 0,0),1,1,1)"&fl=*,score'
But why isn't sorting by functions working? I get this error with any
function I try to sort on.This is a nightly trunk build from Aug 25th.
I see SOLR-1297 was reopened, but that seems to be for edge cases.
Second question: I am using the LatLonType from the Spatial Filtering
wiki, http://wiki.apache.org/solr/SpatialSearch
Are there any distance sorting functions that use this field, or do I
need to have three indexed fields, store_lat_lon, latitude, and
longitude, if I want both filtering and sorting by distance.
Thanks, Scott
Re: Distance sorting with spatial filtering
Posted by Scott K <so...@skister.com>.
I tracked down the problem and found a workaround. If there is a
wildcard entry in schema.xml such as the following.
<!-- Ignore any fields that don't already match an existing field name -->
<dynamicField name="*" type="ignored" multiValued="true" />
then sort by function fails and returns Error 400 can not sort on
unindexed field: <function name>
Removing the name="*" entry from schema.xml is a workaround. I noted
this in the Solr-1297 JIRA entry.
Scott
On Fri, Sep 10, 2010 at 01:40, Lance Norskog <go...@gmail.com> wrote:
> Since no one has jumped in to give the right syntax- yeah, it's a bug.
> Please file a JIRA.
>
> On Thu, Sep 9, 2010 at 9:44 PM, Scott K <so...@skister.com> wrote:
>> On Thu, Sep 9, 2010 at 21:00, Lance Norskog <go...@gmail.com> wrote:
>>> I just checked out the trunk, and branch 3.x This query is accepted on both,
>>> but gives no responses:
>>> http://localhost:8983/solr/select/?q=*:*&sort=dist(2,x_dt,y_dt,0,0)+asc
>>
>> So you are saying when you add the sort parameter you get no results
>> back, but do not get the error I am seeing? Should I open a Jira
>> ticket?
>>
>>> x_dt and y_dt are wildcard fields with the tdouble type. "tdouble"
>>> explicitly says it is stored and indexed. Your 'longitude' and 'latitude'
>>> fields may not be stored?
>>
>> No, they are stored.
>> http://localhost:8983/solr/select?q=*:*&rows=1&wt=xml&indent=true
>> <?xml version="1.0" encoding="UTF-8"?>
>> <response>
>> <lst name="responseHeader">
>> <int name="status">0</int>
>> <int name="QTime">9</int>
>> </lst>
>> <result name="response" numFound="365775" start="0">
>> <doc>
>> ...
>> <double name="latitude">47.6636</double>
>> <double name="longitude">-122.3054</double>
>>
>>
>>> Also, this is accepted on both branches:
>>> http://localhost:8983/solr/select/?q=*:*&sort=sum(1)+asc
>>>
>>> The documentation for sum() does not mention single-argument calls.
>>
>> This also fails
>> http://localhost:8983/solr/select/?q=*:*&sort=sum(1,2)+asc
>> http://localhost:8983/solr/select/?q=*:*&sort=sum(latitude,longitude)+asc
>>
>>
>>> Scott K wrote:
>>>>
>>>> According to the documentation, sorting by function has been a feature
>>>> since Solr 1.5. It seems like a major regression if this no longer
>>>> works.
>>>> http://wiki.apache.org/solr/FunctionQuery#Sort_By_Function
>>>>
>>>> The _val_ trick does not seem to work if used with a query term,
>>>> although I can try some more things to give 0 value to the query term.
>>>>
>>>> On Wed, Sep 8, 2010 at 22:21, Lance Norskog<go...@gmail.com> wrote:
>>>>
>>>>>
>>>>> It says that the field "sum(1)" is not indexed. You don't have a field
>>>>> called 'sum(1)'. I know there has been a lot of changes in query parsing,
>>>>> and sorting by functions may be on the list. But the _val_ trick is the
>>>>> older one and, and you noted, still works. The _val_ trick sets the
>>>>> ranking
>>>>> value to the output of the function, thus indirectly doing what sort=
>>>>> does.
>>>>>
>>>>> Lance
>>>>>
>>>>> Scott K wrote:
>>>>>
>>>>>>
>>>>>> I get the error on all functions.
>>>>>> GET 'http://localhost:8983/solr/select?q=*:*&sort=sum(1)+asc'
>>>>>> Error 400 can not sort on unindexed field: sum(1)
>>>>>>
>>>>>> I tried another nightly build from today, Sep 7th, with the same
>>>>>> results. I attached the schema.xml
>>>>>>
>>>>>> Thanks for the help!
>>>>>> Scott
>>>>>>
>>>>>> On Wed, Sep 1, 2010 at 18:43, Lance Norskog<go...@gmail.com> wrote:
>>>>>>
>>>>>>
>>>>>>>
>>>>>>> Post your schema.
>>>>>>>
>>>>>>> On Mon, Aug 30, 2010 at 2:04 PM, Scott K<so...@skister.com> wrote:
>>>>>>>
>>>>>>>
>>>>>>>>
>>>>>>>> The new spatial filtering (SOLR-1586) works great and is much faster
>>>>>>>> than fq={!frange. However, I am having problems sorting by distance.
>>>>>>>> If I try
>>>>>>>> GET
>>>>>>>>
>>>>>>>> 'http://localhost:8983/solr/select/?q=*:*&sort=dist(2,latitude,longitude,0,0)+asc'
>>>>>>>> I get an error:
>>>>>>>> Error 400 can not sort on unindexed field:
>>>>>>>> dist(2,latitude,longitude,0,0)
>>>>>>>>
>>>>>>>> I was able to work around this with
>>>>>>>> GET 'http://localhost:8983/solr/select/?q=*:* AND _val_:"recip(dist(2,
>>>>>>>> latitude, longitude, 0,0),1,1,1)"&fl=*,score'
>>>>>>>>
>>>>>>>> But why isn't sorting by functions working? I get this error with any
>>>>>>>> function I try to sort on.This is a nightly trunk build from Aug 25th.
>>>>>>>> I see SOLR-1297 was reopened, but that seems to be for edge cases.
>>>>>>>>
>>>>>>>> Second question: I am using the LatLonType from the Spatial Filtering
>>>>>>>> wiki, http://wiki.apache.org/solr/SpatialSearch
>>>>>>>> Are there any distance sorting functions that use this field, or do I
>>>>>>>> need to have three indexed fields, store_lat_lon, latitude, and
>>>>>>>> longitude, if I want both filtering and sorting by distance.
>>>>>>>>
>>>>>>>> Thanks, Scott
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Lance Norskog
>>>>>>> goksron@gmail.com
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>
>>>>>
>>>
>>
>
>
>
> --
> Lance Norskog
> goksron@gmail.com
>
Re: Distance sorting with spatial filtering
Posted by Lance Norskog <go...@gmail.com>.
Since no one has jumped in to give the right syntax- yeah, it's a bug.
Please file a JIRA.
On Thu, Sep 9, 2010 at 9:44 PM, Scott K <so...@skister.com> wrote:
> On Thu, Sep 9, 2010 at 21:00, Lance Norskog <go...@gmail.com> wrote:
>> I just checked out the trunk, and branch 3.x This query is accepted on both,
>> but gives no responses:
>> http://localhost:8983/solr/select/?q=*:*&sort=dist(2,x_dt,y_dt,0,0)+asc
>
> So you are saying when you add the sort parameter you get no results
> back, but do not get the error I am seeing? Should I open a Jira
> ticket?
>
>> x_dt and y_dt are wildcard fields with the tdouble type. "tdouble"
>> explicitly says it is stored and indexed. Your 'longitude' and 'latitude'
>> fields may not be stored?
>
> No, they are stored.
> http://localhost:8983/solr/select?q=*:*&rows=1&wt=xml&indent=true
> <?xml version="1.0" encoding="UTF-8"?>
> <response>
> <lst name="responseHeader">
> <int name="status">0</int>
> <int name="QTime">9</int>
> </lst>
> <result name="response" numFound="365775" start="0">
> <doc>
> ...
> <double name="latitude">47.6636</double>
> <double name="longitude">-122.3054</double>
>
>
>> Also, this is accepted on both branches:
>> http://localhost:8983/solr/select/?q=*:*&sort=sum(1)+asc
>>
>> The documentation for sum() does not mention single-argument calls.
>
> This also fails
> http://localhost:8983/solr/select/?q=*:*&sort=sum(1,2)+asc
> http://localhost:8983/solr/select/?q=*:*&sort=sum(latitude,longitude)+asc
>
>
>> Scott K wrote:
>>>
>>> According to the documentation, sorting by function has been a feature
>>> since Solr 1.5. It seems like a major regression if this no longer
>>> works.
>>> http://wiki.apache.org/solr/FunctionQuery#Sort_By_Function
>>>
>>> The _val_ trick does not seem to work if used with a query term,
>>> although I can try some more things to give 0 value to the query term.
>>>
>>> On Wed, Sep 8, 2010 at 22:21, Lance Norskog<go...@gmail.com> wrote:
>>>
>>>>
>>>> It says that the field "sum(1)" is not indexed. You don't have a field
>>>> called 'sum(1)'. I know there has been a lot of changes in query parsing,
>>>> and sorting by functions may be on the list. But the _val_ trick is the
>>>> older one and, and you noted, still works. The _val_ trick sets the
>>>> ranking
>>>> value to the output of the function, thus indirectly doing what sort=
>>>> does.
>>>>
>>>> Lance
>>>>
>>>> Scott K wrote:
>>>>
>>>>>
>>>>> I get the error on all functions.
>>>>> GET 'http://localhost:8983/solr/select?q=*:*&sort=sum(1)+asc'
>>>>> Error 400 can not sort on unindexed field: sum(1)
>>>>>
>>>>> I tried another nightly build from today, Sep 7th, with the same
>>>>> results. I attached the schema.xml
>>>>>
>>>>> Thanks for the help!
>>>>> Scott
>>>>>
>>>>> On Wed, Sep 1, 2010 at 18:43, Lance Norskog<go...@gmail.com> wrote:
>>>>>
>>>>>
>>>>>>
>>>>>> Post your schema.
>>>>>>
>>>>>> On Mon, Aug 30, 2010 at 2:04 PM, Scott K<so...@skister.com> wrote:
>>>>>>
>>>>>>
>>>>>>>
>>>>>>> The new spatial filtering (SOLR-1586) works great and is much faster
>>>>>>> than fq={!frange. However, I am having problems sorting by distance.
>>>>>>> If I try
>>>>>>> GET
>>>>>>>
>>>>>>> 'http://localhost:8983/solr/select/?q=*:*&sort=dist(2,latitude,longitude,0,0)+asc'
>>>>>>> I get an error:
>>>>>>> Error 400 can not sort on unindexed field:
>>>>>>> dist(2,latitude,longitude,0,0)
>>>>>>>
>>>>>>> I was able to work around this with
>>>>>>> GET 'http://localhost:8983/solr/select/?q=*:* AND _val_:"recip(dist(2,
>>>>>>> latitude, longitude, 0,0),1,1,1)"&fl=*,score'
>>>>>>>
>>>>>>> But why isn't sorting by functions working? I get this error with any
>>>>>>> function I try to sort on.This is a nightly trunk build from Aug 25th.
>>>>>>> I see SOLR-1297 was reopened, but that seems to be for edge cases.
>>>>>>>
>>>>>>> Second question: I am using the LatLonType from the Spatial Filtering
>>>>>>> wiki, http://wiki.apache.org/solr/SpatialSearch
>>>>>>> Are there any distance sorting functions that use this field, or do I
>>>>>>> need to have three indexed fields, store_lat_lon, latitude, and
>>>>>>> longitude, if I want both filtering and sorting by distance.
>>>>>>>
>>>>>>> Thanks, Scott
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>> --
>>>>>> Lance Norskog
>>>>>> goksron@gmail.com
>>>>>>
>>>>>>
>>>>>>
>>>>
>>>>
>>
>
--
Lance Norskog
goksron@gmail.com
Re: Distance sorting with spatial filtering
Posted by Scott K <so...@skister.com>.
On Thu, Sep 9, 2010 at 21:00, Lance Norskog <go...@gmail.com> wrote:
> I just checked out the trunk, and branch 3.x This query is accepted on both,
> but gives no responses:
> http://localhost:8983/solr/select/?q=*:*&sort=dist(2,x_dt,y_dt,0,0)+asc
So you are saying when you add the sort parameter you get no results
back, but do not get the error I am seeing? Should I open a Jira
ticket?
> x_dt and y_dt are wildcard fields with the tdouble type. "tdouble"
> explicitly says it is stored and indexed. Your 'longitude' and 'latitude'
> fields may not be stored?
No, they are stored.
http://localhost:8983/solr/select?q=*:*&rows=1&wt=xml&indent=true
<?xml version="1.0" encoding="UTF-8"?>
<response>
<lst name="responseHeader">
<int name="status">0</int>
<int name="QTime">9</int>
</lst>
<result name="response" numFound="365775" start="0">
<doc>
...
<double name="latitude">47.6636</double>
<double name="longitude">-122.3054</double>
> Also, this is accepted on both branches:
> http://localhost:8983/solr/select/?q=*:*&sort=sum(1)+asc
>
> The documentation for sum() does not mention single-argument calls.
This also fails
http://localhost:8983/solr/select/?q=*:*&sort=sum(1,2)+asc
http://localhost:8983/solr/select/?q=*:*&sort=sum(latitude,longitude)+asc
> Scott K wrote:
>>
>> According to the documentation, sorting by function has been a feature
>> since Solr 1.5. It seems like a major regression if this no longer
>> works.
>> http://wiki.apache.org/solr/FunctionQuery#Sort_By_Function
>>
>> The _val_ trick does not seem to work if used with a query term,
>> although I can try some more things to give 0 value to the query term.
>>
>> On Wed, Sep 8, 2010 at 22:21, Lance Norskog<go...@gmail.com> wrote:
>>
>>>
>>> It says that the field "sum(1)" is not indexed. You don't have a field
>>> called 'sum(1)'. I know there has been a lot of changes in query parsing,
>>> and sorting by functions may be on the list. But the _val_ trick is the
>>> older one and, and you noted, still works. The _val_ trick sets the
>>> ranking
>>> value to the output of the function, thus indirectly doing what sort=
>>> does.
>>>
>>> Lance
>>>
>>> Scott K wrote:
>>>
>>>>
>>>> I get the error on all functions.
>>>> GET 'http://localhost:8983/solr/select?q=*:*&sort=sum(1)+asc'
>>>> Error 400 can not sort on unindexed field: sum(1)
>>>>
>>>> I tried another nightly build from today, Sep 7th, with the same
>>>> results. I attached the schema.xml
>>>>
>>>> Thanks for the help!
>>>> Scott
>>>>
>>>> On Wed, Sep 1, 2010 at 18:43, Lance Norskog<go...@gmail.com> wrote:
>>>>
>>>>
>>>>>
>>>>> Post your schema.
>>>>>
>>>>> On Mon, Aug 30, 2010 at 2:04 PM, Scott K<so...@skister.com> wrote:
>>>>>
>>>>>
>>>>>>
>>>>>> The new spatial filtering (SOLR-1586) works great and is much faster
>>>>>> than fq={!frange. However, I am having problems sorting by distance.
>>>>>> If I try
>>>>>> GET
>>>>>>
>>>>>> 'http://localhost:8983/solr/select/?q=*:*&sort=dist(2,latitude,longitude,0,0)+asc'
>>>>>> I get an error:
>>>>>> Error 400 can not sort on unindexed field:
>>>>>> dist(2,latitude,longitude,0,0)
>>>>>>
>>>>>> I was able to work around this with
>>>>>> GET 'http://localhost:8983/solr/select/?q=*:* AND _val_:"recip(dist(2,
>>>>>> latitude, longitude, 0,0),1,1,1)"&fl=*,score'
>>>>>>
>>>>>> But why isn't sorting by functions working? I get this error with any
>>>>>> function I try to sort on.This is a nightly trunk build from Aug 25th.
>>>>>> I see SOLR-1297 was reopened, but that seems to be for edge cases.
>>>>>>
>>>>>> Second question: I am using the LatLonType from the Spatial Filtering
>>>>>> wiki, http://wiki.apache.org/solr/SpatialSearch
>>>>>> Are there any distance sorting functions that use this field, or do I
>>>>>> need to have three indexed fields, store_lat_lon, latitude, and
>>>>>> longitude, if I want both filtering and sorting by distance.
>>>>>>
>>>>>> Thanks, Scott
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>> --
>>>>> Lance Norskog
>>>>> goksron@gmail.com
>>>>>
>>>>>
>>>>>
>>>
>>>
>
Re: Distance sorting with spatial filtering
Posted by Lance Norskog <go...@gmail.com>.
I just checked out the trunk, and branch 3.x This query is accepted on
both, but gives no responses:
http://localhost:8983/solr/select/?q=*:*&sort=dist(2,x_dt,y_dt,0,0)+asc
x_dt and y_dt are wildcard fields with the tdouble type. "tdouble"
explicitly says it is stored and indexed. Your 'longitude' and
'latitude' fields may not be stored?
Also, this is accepted on both branches:
http://localhost:8983/solr/select/?q=*:*&sort=sum(1)+asc
The documentation for sum() does not mention single-argument calls.
(The name Solr 1.5 is dead- the next will probably be 3.1.)
Scott K wrote:
> According to the documentation, sorting by function has been a feature
> since Solr 1.5. It seems like a major regression if this no longer
> works.
> http://wiki.apache.org/solr/FunctionQuery#Sort_By_Function
>
> The _val_ trick does not seem to work if used with a query term,
> although I can try some more things to give 0 value to the query term.
>
> On Wed, Sep 8, 2010 at 22:21, Lance Norskog<go...@gmail.com> wrote:
>
>> It says that the field "sum(1)" is not indexed. You don't have a field
>> called 'sum(1)'. I know there has been a lot of changes in query parsing,
>> and sorting by functions may be on the list. But the _val_ trick is the
>> older one and, and you noted, still works. The _val_ trick sets the ranking
>> value to the output of the function, thus indirectly doing what sort= does.
>>
>> Lance
>>
>> Scott K wrote:
>>
>>> I get the error on all functions.
>>> GET 'http://localhost:8983/solr/select?q=*:*&sort=sum(1)+asc'
>>> Error 400 can not sort on unindexed field: sum(1)
>>>
>>> I tried another nightly build from today, Sep 7th, with the same
>>> results. I attached the schema.xml
>>>
>>> Thanks for the help!
>>> Scott
>>>
>>> On Wed, Sep 1, 2010 at 18:43, Lance Norskog<go...@gmail.com> wrote:
>>>
>>>
>>>> Post your schema.
>>>>
>>>> On Mon, Aug 30, 2010 at 2:04 PM, Scott K<so...@skister.com> wrote:
>>>>
>>>>
>>>>> The new spatial filtering (SOLR-1586) works great and is much faster
>>>>> than fq={!frange. However, I am having problems sorting by distance.
>>>>> If I try
>>>>> GET
>>>>> 'http://localhost:8983/solr/select/?q=*:*&sort=dist(2,latitude,longitude,0,0)+asc'
>>>>> I get an error:
>>>>> Error 400 can not sort on unindexed field:
>>>>> dist(2,latitude,longitude,0,0)
>>>>>
>>>>> I was able to work around this with
>>>>> GET 'http://localhost:8983/solr/select/?q=*:* AND _val_:"recip(dist(2,
>>>>> latitude, longitude, 0,0),1,1,1)"&fl=*,score'
>>>>>
>>>>> But why isn't sorting by functions working? I get this error with any
>>>>> function I try to sort on.This is a nightly trunk build from Aug 25th.
>>>>> I see SOLR-1297 was reopened, but that seems to be for edge cases.
>>>>>
>>>>> Second question: I am using the LatLonType from the Spatial Filtering
>>>>> wiki, http://wiki.apache.org/solr/SpatialSearch
>>>>> Are there any distance sorting functions that use this field, or do I
>>>>> need to have three indexed fields, store_lat_lon, latitude, and
>>>>> longitude, if I want both filtering and sorting by distance.
>>>>>
>>>>> Thanks, Scott
>>>>>
>>>>>
>>>>>
>>>>
>>>> --
>>>> Lance Norskog
>>>> goksron@gmail.com
>>>>
>>>>
>>>>
>>
Re: Distance sorting with spatial filtering
Posted by Scott K <so...@skister.com>.
According to the documentation, sorting by function has been a feature
since Solr 1.5. It seems like a major regression if this no longer
works.
http://wiki.apache.org/solr/FunctionQuery#Sort_By_Function
The _val_ trick does not seem to work if used with a query term,
although I can try some more things to give 0 value to the query term.
On Wed, Sep 8, 2010 at 22:21, Lance Norskog <go...@gmail.com> wrote:
> It says that the field "sum(1)" is not indexed. You don't have a field
> called 'sum(1)'. I know there has been a lot of changes in query parsing,
> and sorting by functions may be on the list. But the _val_ trick is the
> older one and, and you noted, still works. The _val_ trick sets the ranking
> value to the output of the function, thus indirectly doing what sort= does.
>
> Lance
>
> Scott K wrote:
>>
>> I get the error on all functions.
>> GET 'http://localhost:8983/solr/select?q=*:*&sort=sum(1)+asc'
>> Error 400 can not sort on unindexed field: sum(1)
>>
>> I tried another nightly build from today, Sep 7th, with the same
>> results. I attached the schema.xml
>>
>> Thanks for the help!
>> Scott
>>
>> On Wed, Sep 1, 2010 at 18:43, Lance Norskog<go...@gmail.com> wrote:
>>
>>>
>>> Post your schema.
>>>
>>> On Mon, Aug 30, 2010 at 2:04 PM, Scott K<so...@skister.com> wrote:
>>>
>>>>
>>>> The new spatial filtering (SOLR-1586) works great and is much faster
>>>> than fq={!frange. However, I am having problems sorting by distance.
>>>> If I try
>>>> GET
>>>> 'http://localhost:8983/solr/select/?q=*:*&sort=dist(2,latitude,longitude,0,0)+asc'
>>>> I get an error:
>>>> Error 400 can not sort on unindexed field:
>>>> dist(2,latitude,longitude,0,0)
>>>>
>>>> I was able to work around this with
>>>> GET 'http://localhost:8983/solr/select/?q=*:* AND _val_:"recip(dist(2,
>>>> latitude, longitude, 0,0),1,1,1)"&fl=*,score'
>>>>
>>>> But why isn't sorting by functions working? I get this error with any
>>>> function I try to sort on.This is a nightly trunk build from Aug 25th.
>>>> I see SOLR-1297 was reopened, but that seems to be for edge cases.
>>>>
>>>> Second question: I am using the LatLonType from the Spatial Filtering
>>>> wiki, http://wiki.apache.org/solr/SpatialSearch
>>>> Are there any distance sorting functions that use this field, or do I
>>>> need to have three indexed fields, store_lat_lon, latitude, and
>>>> longitude, if I want both filtering and sorting by distance.
>>>>
>>>> Thanks, Scott
>>>>
>>>>
>>>
>>>
>>> --
>>> Lance Norskog
>>> goksron@gmail.com
>>>
>>>
>
Re: Distance sorting with spatial filtering
Posted by Lance Norskog <go...@gmail.com>.
It says that the field "sum(1)" is not indexed. You don't have a field
called 'sum(1)'. I know there has been a lot of changes in query
parsing, and sorting by functions may be on the list. But the _val_
trick is the older one and, and you noted, still works. The _val_ trick
sets the ranking value to the output of the function, thus indirectly
doing what sort= does.
Lance
Scott K wrote:
> I get the error on all functions.
> GET 'http://localhost:8983/solr/select?q=*:*&sort=sum(1)+asc'
> Error 400 can not sort on unindexed field: sum(1)
>
> I tried another nightly build from today, Sep 7th, with the same
> results. I attached the schema.xml
>
> Thanks for the help!
> Scott
>
> On Wed, Sep 1, 2010 at 18:43, Lance Norskog<go...@gmail.com> wrote:
>
>> Post your schema.
>>
>> On Mon, Aug 30, 2010 at 2:04 PM, Scott K<so...@skister.com> wrote:
>>
>>> The new spatial filtering (SOLR-1586) works great and is much faster
>>> than fq={!frange. However, I am having problems sorting by distance.
>>> If I try
>>> GET 'http://localhost:8983/solr/select/?q=*:*&sort=dist(2,latitude,longitude,0,0)+asc'
>>> I get an error:
>>> Error 400 can not sort on unindexed field: dist(2,latitude,longitude,0,0)
>>>
>>> I was able to work around this with
>>> GET 'http://localhost:8983/solr/select/?q=*:* AND _val_:"recip(dist(2,
>>> latitude, longitude, 0,0),1,1,1)"&fl=*,score'
>>>
>>> But why isn't sorting by functions working? I get this error with any
>>> function I try to sort on.This is a nightly trunk build from Aug 25th.
>>> I see SOLR-1297 was reopened, but that seems to be for edge cases.
>>>
>>> Second question: I am using the LatLonType from the Spatial Filtering
>>> wiki, http://wiki.apache.org/solr/SpatialSearch
>>> Are there any distance sorting functions that use this field, or do I
>>> need to have three indexed fields, store_lat_lon, latitude, and
>>> longitude, if I want both filtering and sorting by distance.
>>>
>>> Thanks, Scott
>>>
>>>
>>
>>
>> --
>> Lance Norskog
>> goksron@gmail.com
>>
>>
Re: Distance sorting with spatial filtering
Posted by Scott K <so...@skister.com>.
I get the error on all functions.
GET 'http://localhost:8983/solr/select?q=*:*&sort=sum(1)+asc'
Error 400 can not sort on unindexed field: sum(1)
I tried another nightly build from today, Sep 7th, with the same
results. I attached the schema.xml
Thanks for the help!
Scott
On Wed, Sep 1, 2010 at 18:43, Lance Norskog <go...@gmail.com> wrote:
> Post your schema.
>
> On Mon, Aug 30, 2010 at 2:04 PM, Scott K <so...@skister.com> wrote:
>> The new spatial filtering (SOLR-1586) works great and is much faster
>> than fq={!frange. However, I am having problems sorting by distance.
>> If I try
>> GET 'http://localhost:8983/solr/select/?q=*:*&sort=dist(2,latitude,longitude,0,0)+asc'
>> I get an error:
>> Error 400 can not sort on unindexed field: dist(2,latitude,longitude,0,0)
>>
>> I was able to work around this with
>> GET 'http://localhost:8983/solr/select/?q=*:* AND _val_:"recip(dist(2,
>> latitude, longitude, 0,0),1,1,1)"&fl=*,score'
>>
>> But why isn't sorting by functions working? I get this error with any
>> function I try to sort on.This is a nightly trunk build from Aug 25th.
>> I see SOLR-1297 was reopened, but that seems to be for edge cases.
>>
>> Second question: I am using the LatLonType from the Spatial Filtering
>> wiki, http://wiki.apache.org/solr/SpatialSearch
>> Are there any distance sorting functions that use this field, or do I
>> need to have three indexed fields, store_lat_lon, latitude, and
>> longitude, if I want both filtering and sorting by distance.
>>
>> Thanks, Scott
>>
>
>
>
> --
> Lance Norskog
> goksron@gmail.com
>
Re: Distance sorting with spatial filtering
Posted by Lance Norskog <go...@gmail.com>.
Post your schema.
On Mon, Aug 30, 2010 at 2:04 PM, Scott K <so...@skister.com> wrote:
> The new spatial filtering (SOLR-1586) works great and is much faster
> than fq={!frange. However, I am having problems sorting by distance.
> If I try
> GET 'http://localhost:8983/solr/select/?q=*:*&sort=dist(2,latitude,longitude,0,0)+asc'
> I get an error:
> Error 400 can not sort on unindexed field: dist(2,latitude,longitude,0,0)
>
> I was able to work around this with
> GET 'http://localhost:8983/solr/select/?q=*:* AND _val_:"recip(dist(2,
> latitude, longitude, 0,0),1,1,1)"&fl=*,score'
>
> But why isn't sorting by functions working? I get this error with any
> function I try to sort on.This is a nightly trunk build from Aug 25th.
> I see SOLR-1297 was reopened, but that seems to be for edge cases.
>
> Second question: I am using the LatLonType from the Spatial Filtering
> wiki, http://wiki.apache.org/solr/SpatialSearch
> Are there any distance sorting functions that use this field, or do I
> need to have three indexed fields, store_lat_lon, latitude, and
> longitude, if I want both filtering and sorting by distance.
>
> Thanks, Scott
>
--
Lance Norskog
goksron@gmail.com