Just beware of performance here. This is fine for smaller indexes, but for larger ones won't work so well. It will need to do this calculation for every document in your index, thereby undoing all benefits of having an inverted index.
If your index (or resultset) is small enough, it can work, but might catch you out later. Upayavira On Fri, Oct 9, 2015, at 10:59 AM, Aman Tandon wrote: > Hi, > > I tried to use the same as mentioned in the url > <http://stackoverflow.com/questions/16258605/query-for-document-that-two-fields-are-equal> > . > > And I used the description field to check because mapping field > is multivalued. > > So I add the fq={!frange%20l=0%20u=1}strdist(title,description,edit) in > my > url, but I am getting this error. As mentioned below. Please take a look. > > *Solr Version 4.8.1* > > *Url is* > http://localhost:8150/solr/core1/select?q.alt=*:*&fl=big*,title,catid&fq={!frange%20l=0%20u=1}strdist(title,description,edit)&defType=edismax > > > <response> > > <lst name="responseHeader"> > > <int name="status">500</int> > > <int name="QTime">8</int> > > <lst name="params"> > > <str name="q.alt">*:*</str> > > <str name="defType">edismax</str> > > <str name="fl">big*,title,catid</str> > > <str name="fq">{!frange l=0 u=1}strdist(title,description,edit)</str> > > </lst> > > </lst> > > <lst name="error"> > > <str name="trace"> > > java.lang.RuntimeException at > > org.apache.solr.search.ExtendedDismaxQParser$ExtendedDismaxConfiguration.<init>(ExtendedDismaxQParser.java:1455) > > at > > org.apache.solr.search.ExtendedDismaxQParser.createConfiguration(ExtendedDismaxQParser.java:239) > > at > > org.apache.solr.search.ExtendedDismaxQParser.<init>(ExtendedDismaxQParser.java:108) > > at > > org.apache.solr.search.ExtendedDismaxQParserPlugin.createParser(ExtendedDismaxQParserPlugin.java:37) > > at org.apache.solr.search.QParser.getParser(QParser.java:315) at > > org.apache.solr.handler.component.QueryComponent.prepare(QueryComponent.java:144) > > at > > org.apache.solr.handler.component.SearchHandler.handleRequestBody(SearchHandler.java:197) > > at > > org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:135) > > at org.apache.solr.core.SolrCore.execute(SolrCore.java:1952) at > > org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter.java:774) > > at > > org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:418) > > at > > org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:207) > > 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:222) > > at > > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) > > at > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) > > at > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) > > at > > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953) > > at > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) > > at > > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) > > at > > org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023) > > at > > org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) > > at > > org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310) > > at > > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > > at > > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > > at java.lang.Thread.run(Thread.java:745) > > </str> > > <int name="code">500</int> > > </lst> > > </response> > > > > With Regards > Aman Tandon > > On Thu, Oct 8, 2015 at 8:07 PM, Alessandro Benedetti < > benedetti.ale...@gmail.com> wrote: > > > Hi agree with Nutch, > > using the Function Range Query Parser, should do your trick : > > > > > > https://lucene.apache.org/solr/5_3_0/solr-core/org/apache/solr/search/FunctionRangeQParserPlugin.html > > > > Cheers > > > > On 8 October 2015 at 13:31, NutchDev <nutchsolru...@gmail.com> wrote: > > > > > Hi Aman, > > > > > > Have a look at this , it has query time approach also using Solr function > > > query, > > > > > > > > > > > http://stackoverflow.com/questions/15927893/how-to-check-equality-of-two-solr-fields > > > > > > > > http://stackoverflow.com/questions/16258605/query-for-document-that-two-fields-are-equal > > > > > > > > > > > > -- > > > View this message in context: > > > > > http://lucene.472066.n3.nabble.com/Exclude-documents-having-same-data-in-two-fields-tp4233408p4233489.html > > > Sent from the Solr - User mailing list archive at Nabble.com. > > > > > > > > > > > -- > > -------------------------- > > > > Benedetti Alessandro > > Visiting card - http://about.me/alessandro_benedetti > > Blog - http://alexbenedetti.blogspot.co.uk > > > > "Tyger, tyger burning bright > > In the forests of the night, > > What immortal hand or eye > > Could frame thy fearful symmetry?" > > > > William Blake - Songs of Experience -1794 England > >
