Re: Must clause with filter queries

2018-05-11 Thread root23
hey shawn i tried debugging actual solr code in local with the following two different forms for frange. So to see if solr is somehow parsing it wrong. But i seed the parsed query that gets put in the filter query pretty much same. query1 -> +_val_:{!frange cost=200 l=30 u=100 incl=true incu=false

Re: Must clause with filter queries

2018-05-10 Thread Susheel Kumar
1. a) is accurate while 2. b) is accurate. if query 1. a) is just for example then its fine but otherwise usually want to use filter on fields which has low cardinality like state, country, gender etc. Name is a high cardinality column and using filter query wouldn't be efficient and also doesn't

Re: Must clause with filter queries

2018-05-09 Thread Shawn Heisey
On 5/9/2018 12:56 PM, root23 wrote: > Thanks for the explanation shawn. I will look at our autowarming time. > Looking at your response i am thinking i might be doing few more things > wrong > 1. Does Must clause with any of the filter query makes any sense or is > automatically implied. > e.g i

Re: Must clause with filter queries

2018-05-09 Thread root23
Thanks for the explanation shawn. I will look at our autowarming time. Looking at your response i am thinking i might be doing few more things wrong 1. Does Must clause with any of the filter query makes any sense or is automatically implied. e.g if i want all the docs with firstName:michael and

Re: Must clause with filter queries

2018-05-08 Thread Shawn Heisey
On 5/8/2018 9:58 AM, root23 wrote: > In case of frange query how do we specify the Must clause ? Looking at how frange works, I'm pretty sure that all queries with frange are going to be effectively single-clause.  So you don't need to specify MUST -- it's implied. > the reason we are using frang

Re: Must clause with filter queries

2018-05-08 Thread root23
Hi Shawn, Thanks for the repsonse. We have multiple clauses. I was just giving an bare bone example. Usually all our queries will have more then one clause. In case of frange query how do we specify the Must clause ? the reason we are using frange instead of the normal syntax is that we need to a

Re: Must clause with filter queries

2018-05-08 Thread Shawn Heisey
On 5/7/2018 9:51 AM, manuj singh wrote: > I am kind of confused how must clause(+) behaves with the filter queries. > e.g i have below query: > q=*:*&fq=+{!frange cost=200 l=NOW-179DAYS u=NOW/DAY+1DAY incl=true > incu=false}date > > So i am filtering documents which are less then 179 old days. > So