Please explain why you do not want to use an extra field. That is the only solution that will perform well on your large index.
wunder Walter Underwood wun...@wunderwood.org http://observer.wunderwood.org/ (my blog) > On Oct 9, 2015, at 7:47 AM, Aman Tandon <amantandon...@gmail.com> wrote: > > 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 >>>>>> >>>> >>> >>