Hey David, it works! Thank you very much. The true is that the docummentation is a little bit confusing, but know It works perfectly.
Regards, - Luis Cappa 2013/3/6 David Smiley (@MITRE.org) <dsmi...@mitre.org> > Ah; bingo! > > The top error in the log is what Solr reports in the HTTP response you > reported but it's the message of the exception wrapped by it in the logs > which is more indicative of the problem: > > Caused by: org.apache.solr.common.SolrException: A ValueSource isn't > directly available from this field. Instead try a query using the distance > as the score. > > That error message (which I wrote) even contains the solution :-) > > You're using geodist() against solr.SpatialRecursivePrefixTreeFieldType > which isn't supported. You can get the distance but not using that > approach. Instead the query itself returns the distance as the score. In > the example schema you'll see a link to documentation about this field type > which is this URL: > http://wiki.apache.org/solr/SolrAdaptersForLuceneSpatial4 > From there click on "Sorting and Relevancy": > > http://wiki.apache.org/solr/SolrAdaptersForLuceneSpatial4#Sorting_and_Relevancy > And you'll see an example query along the lines of what you want: > &fl=*,score&sort=score asc&q={! > score=distance}geo:"Intersects(Circle(54.729696,-98.525391 d=10))" > (the score is the distance in this case) > > ~ David > > > Rakudten wrote > > Hello everyone! > > > > - I´m using Solr 4.1.0. > > > > > > - Yes, without the sort the query works perfectly. > > > > > > - The fieldType is as follows: > > > > > > <field name="geolocation" type="location_rpt" indexed="true" > > stored="true" multiValued="true" /> > > * * > > > > <fieldType name="location_rpt" > > class="solr.SpatialRecursivePrefixTreeFieldType" > > > > > > > spatialContextFactory="com.spatial4j.core.context.jts.JtsSpatialContextFactory" > > distErrPct="0.025" > > maxDistErr="0.000009" > > units="degrees" > > /> > > - The error trace from Solr: > > > > Mar 6, 2013 10:02:29 AM org.apache.solr.common.SolrException log > > SEVERE: org.apache.solr.common.SolrException: sort param could not be > > parsed as a query, and is not a field that exists in the index: geodist() > > at org.apache.solr.search.QueryParsing.parseSort(QueryParsing.java:340) > > at org.apache.solr.search.QParser.getSort(QParser.java:281) > > at > > > org.apache.solr.handler.component.QueryComponent.prepare(QueryComponent.java:123) > > at > > > org.apache.solr.handler.component.SearchHandler.handleRequestBody(SearchHandler.java:187) > > at > > > org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:135) > > at org.apache.solr.core.SolrCore.execute(SolrCore.java:1816) > > at > > > org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter.java:448) > > at > > > org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:269) > > at > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) > > at > > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225) > > at > > > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) > > at > > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) > > at > > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) > > at > > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) > > at > > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) > > at > > > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) > > at > > > org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1001) > > at > > > org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585) > > at > > > org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312) > > at > > > java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) > > at > > > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) > > at java.lang.Thread.run(Thread.java:662) > > Caused by: org.apache.solr.common.SolrException: A ValueSource isn't > > directly available from this field. Instead try a query using the > distance > > as the score. > > at > > > org.apache.solr.schema.AbstractSpatialFieldType.getValueSource(AbstractSpatialFieldType.java:219) > > at > > > org.apache.solr.search.function.distance.HaversineConstFunction.parseSfield(HaversineConstFunction.java:168) > > at > > > org.apache.solr.search.function.distance.HaversineConstFunction.access$200(HaversineConstFunction.java:47) > > at > > > org.apache.solr.search.function.distance.HaversineConstFunction$1.parse(HaversineConstFunction.java:104) > > at > > > org.apache.solr.search.FunctionQParser.parseValueSource(FunctionQParser.java:352) > > at org.apache.solr.search.FunctionQParser.parse(FunctionQParser.java:68) > > at org.apache.solr.search.QParser.getQuery(QParser.java:142) > > at org.apache.solr.search.QueryParsing.parseSort(QueryParsing.java:271) > > ... 22 more > > > > > > I would like to sort by distance and also to return that distance as a fl > > parameter inside the response. > > > > Thank you very much. > > > > Regards, > > > > > > - Luis Cappa > > > > > > 2013/3/5 Chris Hostetter < > > > hossman_lucene@ > > > > > > > >> > >> 1) which version of solr are you using? > >> 2) what is the field & fieldtype for "geolocation" > >> 2) can you try changing your query to "q={!func}geodist()" to verify > that > >> the function works at all? > >> > >> > >> > >> : Date: Tue, 5 Mar 2013 19:30:33 +0100 > >> : From: Luis Cappa Banda < > > > luiscappa@ > > > > > >> : Reply-To: > > > solr-user@.apache > > >> : To: > > > solr-user@.apache > > >> : Subject: Re: Solr 4.1: problems with Spatial Search. > >> : > >> : Without the sort it works perfectly, and there are no more error > >> messages, > >> : just the one I copy&pasted, :-( > >> : El 05/03/2013 19:05, "David Smiley (@MITRE.org)" < > > > DSMILEY@ > > > > > >> : escribió: > >> : > >> : > Hmm; weird. It looks right. Does it work without the sort? -- i.e. > >> does > >> : > the > >> : > filter work? Are there more interesting looking error messages > >> output > >> by > >> : > Solr? > >> : > > >> : > > >> : > Rakudten wrote > >> : > > Hello! > >> : > > > >> : > > I´m trying to sort by geodist() distance, but it seems that I > >> can´t: > >> : > > > >> : > > *The query:* > >> : > > > >> : > > > >> : > > >> > http://192.168.1.129:8080/geo/zones/select?q=*:*&fq={!geofilt}&sfield=geolocation&pt=38.96442,-3.89047&d=10&wt=json&start=0&rows=10&sort=geodist()%20asc > >> : > > > >> : > > *The response:* > >> : > > * > >> : > > * > >> : > > > >> : > > { > >> : > > responseHeader: { > >> : > > status: 400, > >> : > > QTime: 2, > >> : > > params: { > >> : > > d: "10", > >> : > > sort: "geodist() asc", > >> : > > start: "0", > >> : > > q: "*:*", > >> : > > sfield: "geolocation", > >> : > > pt: "38.96442,-3.89047", > >> : > > wt: "json", > >> : > > fq: "{!geofilt}", > >> : > > rows: "10" > >> : > > } > >> : > > }, > >> : > > error: { > >> : > > msg: "sort param could not be parsed as a query, and is not a > field > >> that > >> : > > exists in the index: geodist()", > >> : > > code: 400 > >> : > > } > >> : > > } > >> : > > > >> : > > I´ve read several times the documentation and it seems that this > is > >> the > >> : > > correct way to search filtering by coordinates and sorting by > >> distance, > >> : > > but > >> : > > I doesn´t work. Any suggestions? > >> : > > > >> : > > Also I´ve tried to return the distance as a field via fl params, > >> but > >> I > >> : > > couldn´t. It may help me a lot if anyone could tell me how to do > >> it. > >> : > > > >> : > > Thank you very much in advance! > >> : > > > >> : > > > >> : > > Best regards, > >> : > > > >> : > > > >> : > > - Luis Cappa > >> : > > >> : > > >> : > > >> : > > >> : > > >> : > ----- > >> : > Author: > >> : > http://www.packtpub.com/apache-solr-3-enterprise-search-server/book > >> : > -- > >> : > View this message in context: > >> : > > >> > http://lucene.472066.n3.nabble.com/Solr-4-1-problems-with-Spatial-Search-tp4044868p4044958.html > >> : > Sent from the Solr - User mailing list archive at Nabble.com. > >> : > > >> : > >> > >> -Hoss > > > > > > ----- > Author: > http://www.packtpub.com/apache-solr-3-enterprise-search-server/book > -- > View this message in context: > http://lucene.472066.n3.nabble.com/Solr-4-1-problems-with-Spatial-Search-tp4044868p4045231.html > Sent from the Solr - User mailing list archive at Nabble.com. >
