Re: Exclude documents having same data in two fields

2015-10-10 Thread Walter Underwood
After several days, we finally get the real requirement. It really does waste a lot of time and energy when people won’t tell us that. wunder Walter Underwood wun...@wunderwood.org http://observer.wunderwood.org/ (my blog) > On Oct 10, 2015, at 8:19 AM, Upayavira wrote: > > In which case you'

Re: Exclude documents having same data in two fields

2015-10-10 Thread Upayavira
In which case you'd be happy to wait for 30s for it to complete, in which case the func or frange function query should be fine. Upayavira On Fri, Oct 9, 2015, at 05:55 PM, Aman Tandon wrote: > Thanks Mikhail the suggestion. I will try that on monday will let you > know. > > *@*Walter This was j

Re: Exclude documents having same data in two fields

2015-10-09 Thread Aman Tandon
Thanks Mikhail the suggestion. I will try that on monday will let you know. *@*Walter This was just an random requirement to find those fields which are not same and then reindex only those. I can full index but I was wondering if there might some function or something. With Regards Aman Tandon

Re: Exclude documents having same data in two fields

2015-10-09 Thread Mikhail Khludnev
Aman, You can invoke Terms Component for the filed M, let it returns terms: {a,c,d,f} then you invoke it for field T let it return {b,c,f,e}, then you intersect both lists (it's quite romantic if they are kept ordered), you've got {c,f} and then you applies filter: fq=-((+M:c +T:c) (+M:f +T:f)) et

Re: Exclude documents having same data in two fields

2015-10-09 Thread Walter Underwood
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 wrote: > > No Susheel, As our inde

Re: Exclude documents having same data in two fields

2015-10-09 Thread Aman Tandon
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 wrote: > Hi Aman, Did the problem resolved or still having some errors. > > Thnx > > On Fri, Oct 9, 2015 at 8:28 AM, Aman Tandon > wrote: > > >

Re: Exclude documents having same data in two fields

2015-10-09 Thread Susheel Kumar
Hi Aman, Did the problem resolved or still having some errors. Thnx On Fri, Oct 9, 2015 at 8:28 AM, Aman Tandon wrote: > okay Thanks > > With Regards > Aman Tandon > > On Fri, Oct 9, 2015 at 4:25 PM, Upayavira wrote: > > > Just beware of performance here. This is fine for smaller indexes, but

Re: Exclude documents having same data in two fields

2015-10-09 Thread Aman Tandon
okay Thanks With Regards Aman Tandon On Fri, Oct 9, 2015 at 4:25 PM, Upayavira 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 benefi

Re: Exclude documents having same data in two fields

2015-10-09 Thread Upayavira
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

Re: Exclude documents having same data in two fields

2015-10-09 Thread Aman Tandon
Hi, I tried to use the same as mentioned in the url . 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

Re: Exclude documents having same data in two fields

2015-10-08 Thread Alessandro Benedetti
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 wrote: > Hi Aman, > > Have a look at this , it has query time app

Re: Exclude documents having same data in two fields

2015-10-08 Thread NutchDev
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 contex

Re: Exclude documents having same data in two fields

2015-10-08 Thread Aman Tandon
But I want to find do it at run time without index extra field With Regards Aman Tandon On Thu, Oct 8, 2015 at 11:55 AM, NutchDev wrote: > One option could be creating another boolean field field1_equals_field2 and > set it to true for documents matching it while indexing. Use this field as > a

Re: Exclude documents having same data in two fields

2015-10-07 Thread NutchDev
One option could be creating another boolean field field1_equals_field2 and set it to true for documents matching it while indexing. Use this field as a filter criteria while querying solr. -- View this message in context: http://lucene.472066.n3.nabble.com/Exclude-documents-having-same-data-i