Re: Solr 8.0.0 Delta import add/delete data

2019-04-14 Thread Anuj Bhargava
The database has 120 entries and 2 (not 20 as mentioned earlier) plus new records are added and around the same number deleted. For Full Import it takes approximately 4 minutes to Index. Regards, Anuj On Mon, 15 Apr 2019 at 07:29, Zheng Lin Edwin Yeo wrote: > Have you tried how lo

Re: Multivalue Field lookup

2019-04-14 Thread Zheng Lin Edwin Yeo
You need to set the field which you want to highlight in the hl.fl parameter in your solrconfig.xml. Highlighting can work in String field. Regards, Edwin On Mon, 15 Apr 2019 at 05:53, Kumaresh AK wrote: > How would I go about change by field type to facilitate highlighting ? I > tried hl on my

Re: Solr 8.0.0 Delta import add/delete data

2019-04-14 Thread Zheng Lin Edwin Yeo
Have you tried how long does it take to index all the entries? Regards, Edwin On Fri, 12 Apr 2019 at 12:32, Anuj Bhargava wrote: > We have a MySql database (news) which has the following fields - > posting_id, date, name, currency, country, expiry etc > > The database has more than 120

Re: Solr query particular value of a field last

2019-04-14 Thread Anuj Bhargava
Thanks Saurabh And Prince, Works perfectly. On Sun, 14 Apr 2019 at 17:21, Prince Manohar wrote: > Basically, you need to boost some documents low. > > For this, you can either use solr’s Boost Query ( bq ) or Boost Function > (bf) > parameter. > > For example in your case:- > > If you want the d

Re: Multivalue Field lookup

2019-04-14 Thread Kumaresh AK
How would I go about change by field type to facilitate highlighting ? I tried hl on my current schema and the highlight section is empty. I guess I need to change to multivalue text. Currently it is String Field as these are identifiers and no analysis needed on those On Sun, Apr 14, 2019 at

Re: Optimizing fq query performance

2019-04-14 Thread Shawn Heisey
On 4/13/2019 12:58 PM, John Davis wrote: We noticed a sizable performance degradation when we add certain fq filters to the query even though the result set does not change between the two queries. I would've expected solr to optimize internally by picking the most constrained fq filter first, bu

Re: Shard and replica went down in Solr 6.1.0

2019-04-14 Thread Shawn Heisey
On 4/13/2019 9:29 PM, vishal patel wrote: 2> In production, lots of documents come for indexing within a second.If i do hard commit interval to 60 seconds then in less times open searchers when hard commit execute. Is it ohk for performance? The autoCommit configuration should have openSearch

Re: Optimizing fq query performance

2019-04-14 Thread Erick Erickson
Patches welcome, but how would that be done? There’s no fixed schema at the Lucene level. It’s even possible that no two documents in the index have any fields in common. Given the structure of an inverted index, answering the question “for document X does it have any value?" is rather “interes

Re: bin/post command not working when run from crontab

2019-04-14 Thread Jason Gerlowski
Hi Carsten, I think this is probably worth a jira. I'm not familiar enough with bin/post to say definitively whether the behavior you mention is a bug, or whether it's "expected" in some odd sense. But there's enough uncertainty that I think it's worth recording there. Best, Jason On Fri, Apr

Re: Multivalue Field lookup

2019-04-14 Thread Mikhail Khludnev
Btw, can it be done by highlighting? On Sun, Apr 14, 2019 at 3:22 PM Kumaresh AK wrote: > Hi Mikhail, > Thanks for the response. I see the results have the details I am looking > for. But it is not well structured. I sense that the debug=results is for > understanding the scoring behind the resu

Re: Multivalue Field lookup

2019-04-14 Thread Kumaresh AK
Hi Mikhail, Thanks for the response. I see the results have the details I am looking for. But it is not well structured. I sense that the debug=results is for understanding the scoring behind the results which can be more than what I am looking for. Is there any other way ? The multivalued field ma

Re: Solr query particular value of a field last

2019-04-14 Thread Prince Manohar
Basically, you need to boost some documents low. For this, you can either use solr’s Boost Query ( bq ) or Boost Function (bf) parameter. For example in your case:- If you want the documents with countries A and B to show last in the result, you can use:- bq=( country:A OR country:B )^-1 Note

Re: Solr query particular value of a field last

2019-04-14 Thread Saurabh Sharma
fq=country :c1 OR c2 OR c3&sort=if(termfreq (country,c2),0,1) desc Correcting query. On Sun 14 Apr, 2019, 3:36 PM Saurabh Sharma, wrote: > I would suggest to sort on the basis of condition. First find all the > records and then sort on the basis of condition where you will be putting > spcific

nested documents performance

2019-04-14 Thread Roi Wexler
Hi, we're at the process of testing Solr for its indexing speed which is very impotent to our application. we've witnessed strange behavior that we wish to understand before using it. when we indexed 1M docs it took about 63 seconds but when we indexed the same documents only now we've nested the

Re: Solr query particular value of a field last

2019-04-14 Thread Saurabh Sharma
I would suggest to sort on the basis of condition. First find all the records and then sort on the basis of condition where you will be putting spcific countries below other. fq=country :c1 OR c2 OR c3&sort=if(termfreq (country,c2),1,0) desc Here we are putting c2 below c1 and c3. You can also

Re: Real time get - URL size limitation

2019-04-14 Thread Vincenzo D'Amore
Hi ZarskiJ > 1) I have not tried post as we are using SolrJ version 6.4 - There is no > option to change the method of the request as far as I know from looking at > the documentation. https://lucene.apache.org/solr/6_4_2/solr-solrj/org/apache/solr/client/solrj/SolrClient.html#query-org.apache.

Solr query particular value of a field last

2019-04-14 Thread Anuj Bhargava
I have a field *country*. I need to do a search in which I need to show the search result of a country or some countries, last in the search result for eg. country code *BD*. What query should I use to get the above result. fq=country:???&q=*%3A*

Re: Multivalue Field lookup

2019-04-14 Thread Mikhail Khludnev
Hello, Kumaresh! If you turn it to q you may try debug=results&debug.explain.structured=true with some performance impact. On Sun, Apr 14, 2019 at 2:41 AM Kumaresh AK wrote: > Hello! > I am new to SOLR. This is my field type definition: > > > > stored="true" multiValued="true" omitTermFreqAndP