Re: Question on sorting

2020-07-22 Thread Saurabh Sharma
Hi, It is because field is string and numbers are getting sorted lexicographically.It has nothing to do with number of digits. Thanks Saurabh On Thu, Jul 23, 2020, 11:24 AM Srinivas Kashyap wrote: > Hello, > > I have schema and field definition as shown below: > > omitNorms="true"/> > > > /

multiple sort terms in json facets sorting

2020-05-13 Thread Saurabh Sharma
multiple sort parameters? json.facet={p:{type : terms,field : P_G,*sort:{ sortingScore:desc , x:desc}*,limit:10,offset:10,facet:{sortingScore : "avg(product(C,M,M))",x:"max(N)",stats:{type:terms,limit:100,field:CONF,facet:{minPrice:"min(N)",minArea:"min(S)"} Thanks Saurabh Sharma

Re: Solr grouping with offset

2020-02-14 Thread Saurabh Sharma
gt; > > > > > Next approach was to use facet first with facet.mincount=3, then > > > > > find docs ids by every facet result and then delete docs by id. > > > > > That way seems to me too complicated for the task. > > > -Original Message---

Re: Solr grouping with offset

2020-02-14 Thread Saurabh Sharma
Hi, If you want to sort on your field and want to put a count restriction too then you have to use mincount. That seems to be best approach for your problem. Thanks Saurabh On Fri, Feb 14, 2020, 6:24 PM Vadim Ivanov < vadim.iva...@spb.ntk-intourist.ru> wrote: > Example of gtouping with empty gr

Re: sorting groups on the basis of average of a field in documents

2020-01-13 Thread Saurabh Sharma
Hi Erick, I am using json facets and was able to achieve desired result using them. I was looking for some possibilities for same in groups. Doing it using json facets is last option. Thank Saurabh Sharma On Mon, Jan 13, 2020, 7:17 PM Erick Erickson wrote: > This might help: >

sorting groups on the basis of average of a field in documents

2020-01-12 Thread Saurabh Sharma
solve this problem? Thanks Saurabh Sharma

Re: Edismax ignoring queries containing booleans

2020-01-06 Thread Saurabh Sharma
It should work well. I have just tested the same with 8.3.0. Thanks Saurabh Sharma On Mon, Jan 6, 2020, 4:31 PM Claire Pollard wrote: > I'm using: > > recordID:(18 OR 19 OR 20) > > Which should return 2 records (as 18 doesn't exist), but it returns none. > recordID

Re: Edismax ignoring queries containing booleans

2020-01-06 Thread Saurabh Sharma
Please share the query which you are creating. On Mon, Jan 6, 2020, 3:52 PM Claire Pollard wrote: > In Solr 8.3.0 I've got an edismax query parser in my search handler, and > it seems to be ignoring Boolean operators such as AND and OR when searching > using an IntPointField. > > I was hoping to

Re: How to control the number of grouped results [DRUPAL]

2019-12-02 Thread Saurabh Sharma
You can use group.limit parameter to get required number of results per group. This value is 1 result per group by default. On Mon, Dec 2, 2019, 7:58 PM alee2 wrote: > Hello everyone, I need some help with the number of results that is > generated > per group, what I need is to control how many

Re: Add certain documents right after particular document

2019-07-20 Thread Saurabh Sharma
Hi, You can add recommendations as child documents and use block join for retrieval. By adding as child it will easy for you to keep track of the recommendations. Thanks Saurabh On Sun, Jul 21, 2019, 8:16 AM Venkateswarlu Bommineni wrote: > Hello Team, > > Apologies , if you feel this question

Re: Question regarding Solr fq query

2019-06-28 Thread Saurabh Sharma
Hi, Images are not visible. Please upload on some image sharing platform and share the link. Thanks On Fri, 28 Jun, 2019, 11:00 PM Krishna Kammadanam, wrote: > Hello, > > > > I am a back-end developer working with Solr 4.0 version. > > > > I am running into so many issues, but trying to unders

Querying _nest_path_ while querying child

2019-06-28 Thread Saurabh Sharma
nest_path_. Suppose I do have a nested path /req#/PD#0/A#1 How can I reach all the documents under PD? q={!parent which='-_nest_path_:/req/PD/'} is not working for me. Thanks Saurabh Sharma

Optimal number of facet threads

2019-06-02 Thread Saurabh Sharma
Hi All, I am trying to use fcs method of faceting and set the facet thread count to 3 .But when I check the thread dump around 15 threads are visible for faceting. Do setting facet thread count to 3 open 3 thread for each segment? On what basis should we decide no facet threads? Thanks

Optimal number of facet threads

2019-05-31 Thread Saurabh Sharma
Hi All, I am trying to use fcs method of faceting and set the facet thread count to 3 .But when I check the thread dump around 15 threads are visible for faceting. Do setting facet thread count to 3 open 3 thread for each segment? On what basis should we decide no facet threads? Thanks Saurabh

Re: Very low filter cache hit ratio

2019-05-29 Thread Saurabh Sharma
about efficient usage of various caches and their internal working. Thanks Saurabh On Wed 29 May, 2019, 6:53 PM Shawn Heisey, wrote: > On 5/29/2019 6:57 AM, Saurabh Sharma wrote: > > What can be the possible reasons for low cache usage? > > How can I leverage cache feature for high

Very low filter cache hit ratio

2019-05-29 Thread Saurabh Sharma
possible reasons for low cache usage? How can I leverage cache feature for high traffic indexes? Thanks Saurabh Sharma

Re: very high query time on solr due to high CPU usage

2019-05-25 Thread Saurabh Sharma
Hi, Link to image https://ibb.co/8g6gXwr Thanks & Regards On Sat 25 May, 2019, 6:09 PM Shawn Heisey, wrote: > On 5/25/2019 5:11 AM, Saurabh Sharma wrote: > > I again faced the issue and restarting the leader worked for me this > time. > > Please find attached the t

Re: very high query time on solr due to high CPU usage

2019-05-25 Thread Saurabh Sharma
you. Regards Saurabh On Sun, May 12, 2019 at 2:51 AM Shawn Heisey wrote: > On 5/11/2019 12:49 PM, Saurabh Sharma wrote: > > Full collection is present on all 3 nodes.I have checked max docs on > every > > node and they were around 1.5 million on each node with 0.9 Millions &g

Re: very high query time on solr due to high CPU usage

2019-05-11 Thread Saurabh Sharma
traffic , cache miss iincreases and solr start doing run time comuptations resulting in high CPU usage.I am not being able to find any other explanation as of now. Thanks Saurabh Sharma On Sat, May 11, 2019 at 8:58 PM Shawn Heisey wrote: > On 5/11/2019 8:05 AM, Saurabh Sharma wrote: >

very high query time on solr due to high CPU usage

2019-05-11 Thread Saurabh Sharma
Hi All , I have been observing a very unique pattern in our solr resource usage. I am running a cluster with 3 nodes and RAM on each node is 12GB. We are doing hard commits every 1 minute and soft commits every 15 seconds. Under normal circumstances solr response time is ~15 ms and CPU usage of ar

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

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: Need information on EofExceptions in solr 4.8.1

2019-03-19 Thread Saurabh Sharma
Hi, Seems like it is not a problem with solr. It is happening due to stream termination at the jetty. Please make sure your client is not setting very low read timeout. You can also increase max sessions timeout and idleTimeout at jetty level. Thanks Saurabh Sharma On Tue, Mar 19, 2019 at 11:19

Re: questions regrading stored fields role in query time

2019-02-26 Thread Saurabh Sharma
way to tell is to tests with > expected indexing/partial updates load and see if/how much it affects > performances. > > HTH, > Emir > -- > Monitoring - Log Management - Alerting - Anomaly Detection > Solr & Elasticsearch Consulting Support Training - http://sematext.com

questions regrading stored fields role in query time

2019-02-26 Thread Saurabh Sharma
Hi All , I am new here on this channel. Few days back we upgraded our solr cloud to version 7.3 and doing real-time document posting with 15 seconds soft commit and 2 minutes hard commit time.As of now we posting full document to solr which includes data accumulations from various sources. Now w