I´ve doing some performance tests and I´ve noticed that with the new query syntax that David told me to use the QTime increases a lot. I´ve got an index with up to 8 million docs and sometimes the query response delays three, four or more seconds until finishes. Is that normal?
2013/3/6 Luis Cappa Banda <luisca...@gmail.com> > 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<http://192.168.1.129:8080/geo/zones/select?q=*:*&fq=%7B!geofilt%7D&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. >> > >
