No Susheel, As our index size is 62 GB so it seems hard to find those records.
With Regards Aman Tandon On Fri, Oct 9, 2015 at 7:30 PM, Susheel Kumar <susheel2...@gmail.com> wrote: > Hi Aman, Did the problem resolved or still having some errors. > > Thnx > > On Fri, Oct 9, 2015 at 8:28 AM, Aman Tandon <amantandon...@gmail.com> > wrote: > > > okay Thanks > > > > With Regards > > Aman Tandon > > > > On Fri, Oct 9, 2015 at 4:25 PM, Upayavira <u...@odoko.co.uk> wrote: > > > > > 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 > > > > > > > > > > >
