That's nice, I thought it was released later. Is your id field docvalued? All the exported fields have to be. No other ideas from me.
Regards, Alex. ---- Newsletter and resources for Solr beginners and intermediates: http://www.solr-start.com/ On 4 October 2016 at 23:40, Nkechi Achara <nkach...@googlemail.com> wrote: > Hey Alex, > > According to the release notes it was in 4.10.3: > http://lucene.apache.org/solr/4_10_3/changes/Changes.html > > > 1. SOLR-5244 <http://issues.apache.org/jira/browse/SOLR-5244>: Exporting > Full Sorted Result Sets > (Erik Hatcher, Joel Bernstein) > > > On 4 October 2016 at 18:29, Alexandre Rafalovitch <arafa...@gmail.com> > wrote: > >> I don't think that functionality is available until Solr 6. Check the >> release notes. >> >> Regards, >> Alex. >> >> On 4 Oct 2016 10:53 PM, "Nkechi Achara" <nkach...@googlemail.com> wrote: >> >> > Hey Alex, >> > >> > I am using a very old version 4.10.3 on CDH 5.5.2. >> > >> > Thanks! >> > >> > On 4 October 2016 at 17:52, Alexandre Rafalovitch <arafa...@gmail.com> >> > wrote: >> > >> > > What version of Solr are you running? >> > > >> > > I think there is another component that needs to be defined. Solr 6.2 >> > > examples have it. >> > > >> > > Regards, >> > > Alex >> > > >> > > On 4 Oct 2016 10:29 PM, "Nkechi Achara" <nkach...@googlemail.com> >> wrote: >> > > >> > > > I have followed the instructions here for setting up an Export >> Handler >> > > for >> > > > Solr and I am having issues when trying to retrieve the data: >> > > > >> > > > Java.io.IOException: org.apache.solr.search.SyntaxError: xport >> > RankQuery >> > > > is >> > > > required for xsort: rq={!xport} >> > > > >> > > > at >> > > > org.apache.solr.response.SortingResponseWriter.write( >> > > > SortingResponseWriter.java:100) >> > > > >> > > > at >> > > > org.apache.solr.servlet.SolrDispatchFilter.writeResponse( >> > > > SolrDispatchFilter.java:813) >> > > > >> > > > at >> > > > org.apache.solr.servlet.SolrDispatchFilter.doFilter( >> > > > SolrDispatchFilter.java:437) >> > > > >> > > > at >> > > > org.apache.solr.servlet.SolrDispatchFilter.doFilter( >> > > > SolrDispatchFilter.java:211) >> > > > >> > > > at >> > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( >> > > > ApplicationFilterChain.java:235) >> > > > >> > > > at >> > > > org.apache.catalina.core.ApplicationFilterChain.doFilter( >> > > > ApplicationFilterChain.java:206) >> > > > >> > > > at >> > > > org.apache.solr.servlet.SolrHadoopAuthenticationFilter$2.doFilter( >> > > > SolrHadoopAuthenticationFilter.java:394) >> > > > >> > > > at >> > > > org.apache.hadoop.security.authentication.server. >> > > > AuthenticationFilter.doFilter(AuthenticationFilter.java:589) >> > > > >> > > > at >> > > > org.apache.hadoop.security.token.delegation.web. >> > > > DelegationTokenAuthenticationFilter.doFilter( >> > > > DelegationTokenAuthenticationFilter.java:291) >> > > > >> > > > at >> > > > org.apache.hadoop.security.authentication.server. >> > > > AuthenticationFilter.doFilter(AuthenticationFilter.java:552) >> > > > >> > > > at >> > > > org.apache.solr.servlet.SolrHadoopAuthenticationFilter.doFilter( >> > > > SolrHadoopAuthenticationFilter.java:399) >> > > > >> > > > at >> > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( >> > > > ApplicationFilterChain.java:235) >> > > > >> > > > at >> > > > org.apache.catalina.core.ApplicationFilterChain.doFilter( >> > > > ApplicationFilterChain.java:206) >> > > > >> > > > at org.apache.solr.servlet.HostnameFilter.doFilter( >> > > HostnameFilter.java:86) >> > > > >> > > > at >> > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( >> > > > ApplicationFilterChain.java:235) >> > > > >> > > > at >> > > > org.apache.catalina.core.ApplicationFilterChain.doFilter( >> > > > ApplicationFilterChain.java:206) >> > > > >> > > > at >> > > > org.apache.catalina.core.StandardWrapperValve.invoke( >> > > > StandardWrapperValve.java:233) >> > > > >> > > > at >> > > > org.apache.catalina.core.StandardContextValve.invoke( >> > > > StandardContextValve.java:191) >> > > > >> > > > at >> > > > org.apache.catalina.core.StandardHostValve.invoke( >> > > > StandardHostValve.java:127) >> > > > >> > > > at >> > > > org.apache.catalina.valves.ErrorReportValve.invoke( >> > > > ErrorReportValve.java:103) >> > > > >> > > > at >> > > > org.apache.catalina.core.StandardEngineValve.invoke( >> > > > StandardEngineValve.java:109) >> > > > >> > > > at >> > > > org.apache.catalina.connector.CoyoteAdapter.service( >> > > > CoyoteAdapter.java:293) >> > > > >> > > > at >> > > > org.apache.coyote.http11.Http11Processor.process( >> > > Http11Processor.java:861) >> > > > >> > > > at >> > > > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler. >> > > > process(Http11Protocol.java:620) >> > > > >> > > > at org.apache.tomcat.util.net.JIoEndpoint$Worker.run( >> > > JIoEndpoint.java:489) >> > > > >> > > > at java.lang.Thread.run(Thread.java:745) >> > > > >> > > > Caused by: org.apache.solr.search.SyntaxError: xport RankQuery is >> > > required >> > > > for xsort: rq={!xport} >> > > > >> > > > ... 26 more >> > > > >> > > > I have set up the solrconfig.xml as is mentioned on this instruction: >> > > > Exporting >> > > > Result Sets >> > > > <https://cwiki.apache.org/confluence/display/solr/ >> > Exporting+Result+Sets> >> > > > So >> > > > I have added: >> > > > >> > > > <requestHandler name="/export" class="solr.SearchHandler"> >> > > > >> > > > <lst name="invariants"> >> > > > >> > > > <str name="rq">{!xport}</str> >> > > > >> > > > <str name="wt">xsort</str> >> > > > >> > > > <str name="distrib">false</str> >> > > > >> > > > </lst> >> > > > >> > > > <arr name="components"> >> > > > >> > > > <str>query</str> >> > > > >> > > > </arr> >> > > > >> > > > </requestHandler> >> > > > >> > > > But when I use the following query I get the error stated above: >> > > > >> > > > http://big-d-cluster:8983/solr/trading/export?q=*%3A*& >> > > > fl=id&sort=tradeTimestamp+desc >> > > > >> > > > Any idea what could be causing this? >> > > > >> > > > >> > > > Thanks in advance, >> > > > >> > > > K >> > > > >> > > >> > >>