Re: Facet Query performance

2019-07-08 Thread Shawn Heisey
On 7/8/2019 12:00 PM, Midas A wrote: Number of Docs :50+ docs Index Size: 300 GB RAM: 256 GB JVM: 32 GB Half a million documents producing an index size of 300GB suggests *very* large documents. That typically produces an index with fields that have very high cardinality, due to text tok

Re: Facet Query performance

2019-07-08 Thread Shawn Heisey
On 7/8/2019 3:08 AM, Midas A wrote: I have enabled docvalues on facet field but query is still taking time. How i can improve the Query time . docValues="true" multiValued="true" termVectors="true" /> *Query: * There's very little information here -- only a single field definition and th

Re: Facet Query performance

2019-07-08 Thread Midas A
Hi How i can know whether DocValues are getting used or not ? Please help me here . On Mon, Jul 8, 2019 at 2:38 PM Midas A wrote: > Hi , > > I have enabled docvalues on facet field but query is still taking time. > > How i can improve the Query time . > docValues="true" multiValued="true" termV

Re: facet query when using word 'AND'

2017-09-06 Thread Erick Erickson
I typed the below then noticed that the field that has "I have a pen AND an apple" is called "body" and you're faceting and searching on a field called "suggest". The below is still relevant if there is still a problem though ;) Your problem isn't faceting, right? It's that you aren't matching any

Re: facet query when using word 'AND'

2017-09-06 Thread Shawn Heisey
On 9/6/2017 3:48 AM, Noriyuki TAKEI wrote: > I use facet query,but I found it dose not work when using 'AND'. > > I woud like to use facet query using 'AND' as not Operator but simple word. With the standard or edismax parser, AND in all uppercase is interpreted as an operator.  There are two ways

Re: Facet query - exlude main query

2017-02-21 Thread Jacques du Rand
Oh right right ! Sorry late night :) Thank You Chris On 21 February 2017 at 20:30, Chris Hostetter wrote: > > : Maybe I'm doing something wrong ? > : /select?q.op=OR&mm=2&q={!tag=mq}nissan&qf=name%20name_ > raw&wt=json&start=0&rows=20&facet.field={!ex=tag_mq}feature_s_1_make > > that url st

Re: Facet query - exlude main query

2017-02-21 Thread Chris Hostetter
: Maybe I'm doing something wrong ? : /select?q.op=OR&mm=2&q={!tag=mq}nissan&qf=name%20name_raw&wt=json&start=0&rows=20&facet.field={!ex=tag_mq}feature_s_1_make that url still contains "ex=tag_mq" .. which is looking for a query with a tag named "tag_mq" .. in your q param you are using a t

Re: Facet query - exlude main query

2017-02-21 Thread Jacques du Rand
Maybe I'm doing something wrong ? /select?q.op=OR&mm=2&q={!tag=mq}nissan&qf=name%20name_raw&wt=json&start=0&rows=20&facet.field={!ex=tag_mq}feature_s_1_make Still only getting ONE facet value ? { status: 0, QTime: 5, params: { mm: "2", facet.field: [ "{!ex=tag_mq}feature_s_1_make", "{!ex=tag

Re: Facet query - exlude main query

2017-02-21 Thread Chris Hostetter
: facet.field: [ : "{!ex=tag_make,tag_model,tag_mq}feature_s_1_make", : "{!ex=tag_model}feature_s_2_model" ... : q: "{!tag=mq}nissan", You are attempting to exclude tags named "tag_make", "tag_model", and "tag_mq" -- but the name of the tag you are using in the query is "mq" if you incl

Re: Facet query - exlude main query

2017-02-21 Thread Jacques du Rand
Sure.. So this is for a car search-application If i change: q={!tag=mq}nissan to q=*:* I get all the makes. VAR ECHO: responseHeader: { status: 0, QTime: 4, params: { mm: "2", facet.field: [ "{!ex=tag_make,tag_model,tag_mq}feature_s_1_make", "{!ex=tag_model}feature_s_2_model" ], qs: "5",

Re: Facet query - exlude main query

2017-02-21 Thread Chris Hostetter
: Solr3.1 Starting with Solr 3.1, the : primary relevance query (i.e. the one normally specified by the *q* parameter) : may also be excluded. : : But doesnt show me how to exlude it ?? same tag + ex local params, as you had in your example... : 2. q=

Re: facet query performance

2016-11-14 Thread Toke Eskildsen
On Mon, 2016-11-14 at 11:36 +0530, Midas A wrote: > How to improve facet query performance 1) Don't shard unless you really need to. Replicas are fine. 2) If the problem is the first facet call, then enable DocValues and re-index. 3) Keep facet.limit <= 100, especially if you shard. and most im

Re: facet query is not working

2015-06-18 Thread Alessandro Benedetti
If he has not put any appends or invariant in the request handler, facet=true is mandatory to activate the facets. I haven't tried those specific facet queries . I hope the problem was not simply he didn't activate faceting ... 2015-06-18 10:35 GMT+01:00 Mikhail Khludnev : > isn't facet=true ne

Re: facet query is not working

2015-06-18 Thread Mikhail Khludnev
isn't facet=true necessary? On Thu, Jun 18, 2015 at 12:03 PM, Midas A wrote: > > http://localhost:8983/solr/col/select?q=*:*&sfield=geolocation&pt=26.697,83.1876&facet.query={!frange%20l=0%20u=50}geodist()&facet.query={!frange%20l=50.001%20u=100}geodist()&&wt=json > > > I am not getting facet re

Re: facet query

2012-12-26 Thread Billy Newman
ache.org/solr/SimpleFacetParameters for more > details > > On Friday, December 21, 2012, hank williams wrote: > >> Great, thank you. >> >> > Date: Fri, 21 Dec 2012 14:42:13 +0100 >> > From: r@solr.pl >> > To: solr-user@lucene.apache.org >> >

Re: facet query

2012-12-25 Thread Anirudha Jadhav
Please see http://wiki.apache.org/solr/SimpleFacetParameters for more details On Friday, December 21, 2012, hank williams wrote: > Great, thank you. > > > Date: Fri, 21 Dec 2012 14:42:13 +0100 > > From: r@solr.pl > > To: solr-user@lucene.apache.org >

RE: facet query

2012-12-21 Thread hank williams
Great, thank you. > Date: Fri, 21 Dec 2012 14:42:13 +0100 > From: r@solr.pl > To: solr-user@lucene.apache.org > Subject: Re: facet query > > Hello! > > Try facet.mincount=1, that should help. > > -- > Regards, > Rafał Kuć > Sematext :: http:/

Re: facet query

2012-12-21 Thread Rafał Kuć
Hello! Try facet.mincount=1, that should help. -- Regards, Rafał Kuć Sematext :: http://sematext.com/ :: Solr - Lucene - Nutch - ElasticSearch > Hi, is there a way with facets to say, return facets that are not > 0? I have &facet=true&facet.field=office&facet.field=name as my > facet paramete

Re: Facet Query using Dates

2012-01-10 Thread Mauro Asprea
I think I solve it... It seems to be because of the - that's just before the query facet name -- Mauro Asprea E-Mail: mauroasp...@gmail.com Mobile: +34 654297582 Skype: mauro.asprea On Tuesday, January 10, 2012 at 11:33 AM, Mauro Asprea wrote: > Hi, I;m having issues using the "new" way

Re: Facet Query

2011-05-31 Thread Erick Erickson
I'm guessing you're faceting on an analyzed field. This is usually a bad idea. What is the use-case you're trying to solve? Best Erick On Fri, May 27, 2011 at 12:51 AM, Jasneet Sabharwal wrote: > Hi > > When I do a facet query on my data, it shows me a list of all the words > present in my datab

Re: Facet Query

2011-05-27 Thread Juan Antonio Farré Basurte
Are you talking about a facet query or a facet field? If it's a facet query, I don't get what's going on. If it's a facet field... well, if it's a fixed set of words you're interested in, filter the query to only those words and you'll get counts only for them. If you just need to filter out comm

Re: Facet Query

2011-05-27 Thread Chandan Tamrakar
which analyzer do you use for indexing ? You could exclude those stop words during indexing http://wiki.apache.org/solr/AnalyzersTokenizersTokenFilters On Fri, May 27, 2011 at 1:36 PM, Jasneet Sabharwal < jasneet.sabhar...@ngicorporation.com> wrote: > Hi > > When I do a facet query on my data

Re: Facet Query Question

2011-02-27 Thread Tim Christensen
My actual: INFO: [] webapp=null path=/select params={timeAllowed=3&qt=dismax&q=columbia&rows=1&facet.field={!ex%3Dcat}categories&facet.field={!ex%3Dadv}adventures&facet=true&facet.limit=-1&facet.mincount=1&fq={!tag%3Dcat}categories:Boots&fq={!tag%3Dadv}adventures:Camping} hits=1 status=0 QTi

Re: Facet Query Question

2011-02-27 Thread Tim Christensen
Sorry. It was hand typed, it is the other way around. It is part of the actual, but I did not copy and paste it. q=query&fq={!tag=cat}categories:Jackets&fq={!tag=adv}adventures:Camping&facet.field={!ex=cat}categories&facet.field={!ex=adv}adventures On Feb 27, 2011, at 5:48 PM, Yonik Seeley wrote

Re: Facet Query Question

2011-02-27 Thread Yonik Seeley
On Sun, Feb 27, 2011 at 7:32 PM, Tim Christensen wrote: > q=query&fq={!ex=cat}categories:Jackets&fq={!ex=adv}adventures:Camping&facet.field={!tag=cat}categories&facet.field={!tag=adv}adventures If this is the actual command you used, it looks like you switched "ex" and "tag"? -Yonik http://lucid

Re: Facet Query Question

2011-02-27 Thread Tim Christensen
Okay -- so I did see that before and I tested it. It does work for example when I do this: q=query&fq={!ex=cat}categories:Jackets&facet.field={!tag=cat}categories Thank you for that part. What I don't get is any of the other facet fields returning their full list of values. So in my case I need

Re: Facet Query Question

2011-02-27 Thread Jan Høydahl
Hi, LocalParam {!tag} and {!ex} will help you: http://wiki.apache.org/solr/SimpleFacetParameters#Tagging_and_excluding_Filters -- Jan Høydahl, search solution architect Cominvent AS - www.cominvent.com On 28. feb. 2011, at 00.41, Tim Christensen wrote: > Hi, > > I am trying to do the following

Re: Facet Query Question

2011-02-27 Thread Rob Casson
if i'm understanding your question, it sounds like localparams/tagging/exclusion might be what you want: http://wiki.apache.org/solr/SimpleFacetParameters#Multi-Select_Faceting_and_LocalParams hth, rob On Sun, Feb 27, 2011 at 6:41 PM, Tim Christensen wrote: > Hi, > > I am trying to do the

Re: Facet Query Question

2011-02-27 Thread Ahmet Arslan
> I am trying to do the following: > > Where a query might return: > > Facet 1 > A > B > C > > Facet 2 > X > Y > Z > > User selects Facet 1 option A. Normally this paradigm would > contract the results as in a refining paradigm. That would > be fine and the obvious UI change. But by doing so, F

Re: Facet Query

2011-02-04 Thread Bagesh Sharma
yes it works fine ... thanks -- View this message in context: http://lucene.472066.n3.nabble.com/Facet-Query-tp2422212p2424155.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Facet Query

2011-02-04 Thread Grijesh
No ,Facet query and fq parameters work with any type of query. when you will search for facet.query=city:mumbai then it will return facet like 3 Facet query is for faceting against perticullar query. If you wants result for that query then you have to go for fq=city:mumbai - Thanx:

Re: Facet query problem

2010-04-22 Thread Erik Hatcher
I'm taking an educated guess that this field is a "string" field. In that case, range queries are lexicographical (1, 10, 2, 3, 4...). Use a numeric field type to have range queries work properly. See Solr's example schema.xml for details on these types and range queries. Erik

RE: Facet query with special characters

2009-12-09 Thread Peter 4U
o: solr-user@lucene.apache.org > Subject: RE: Facet query with special characters > > > : Note that I am (supposed to be) indexing/searching without analysis > : tokenization (if that's the correct term) - i.e. field values like > : 'pds-comp.domain' shouldn'

RE: Facet query with special characters

2009-12-08 Thread Chris Hostetter
: Note that I am (supposed to be) indexing/searching without analysis : tokenization (if that's the correct term) - i.e. field values like : 'pds-comp.domain' shouldn't be (and I believe aren't) broken up as in : 'pds', 'comp' 'domain' etc. (e.g. using the 'text_ws' fieldtype). ... : Wh

RE: Facet query with special characters

2009-12-08 Thread Peter 4U
? Thanks! Peter > Date: Mon, 7 Dec 2009 15:30:47 -0800 > From: hossman_luc...@fucit.org > To: solr-user@lucene.apache.org > Subject: Re: Facet query with special characters > > > > : When performing a facet query where part of the value portion has a > : special c

Re: Facet query with special characters

2009-12-07 Thread Chris Hostetter
: When performing a facet query where part of the value portion has a : special character (a minus sign in this case), the query returns zero : results unless I put a wildcard (*) at the end. check your analysis configuration for this fieldtype, in particular look at what debugQuery produces

Re: Facet query with special characters

2009-12-03 Thread Lance Norskog
Backslash is the escape character for colon, hyphen, parentheses, brackets, curly braces, tilde, caret. (Did I miss any?) On Thu, Dec 3, 2009 at 7:59 AM, Peter 4U wrote: > > Hello Solr Forum, > > > > I believe I have found a solution (workaround?) for performing an explicit > (non-wildcarded) fi

RE: Facet query with special characters

2009-12-03 Thread Peter 4U
Hello Solr Forum, I believe I have found a solution (workaround?) for performing an explicit (non-wildcarded) field query with values that contain special (escaped) characters. Instead of: field:"value-with-escape-chars" change this to: field:["value-with-escape-chars" TO "value-w

Re: Facet query help

2009-10-15 Thread Chris Hostetter
: the original pastie(http://pastie.org/650932). I tried the fq query body with : quotes and without quotes. the entire fq param shouldn't be in quotes ... just the value that you want to query on (since it's a string field and you want the whole field treated as a single string... fq =

Re: Facet query help

2009-10-12 Thread Tommy Chheng
ok, so fq != facet.query. i thought it was an alias. I'm trying your suggestion fq=Memory_s:"1 GB" and now it's returning zero documents even though there is one document that has "tommy" and "Memory_s:1 GB" as seen in the original pastie(http://pastie.org/650932). I tried the fq query body wit

Re: Facet query help

2009-10-12 Thread Shalin Shekhar Mangar
On Mon, Oct 12, 2009 at 6:07 AM, Tommy Chheng wrote: > The dummy data set is composed of 6 docs. > > My query is set for 'tommy' with the facet query of Memory_s:1+GB > > http://lh:8983/solr/select/?facet=true&facet.field=CPU_s&facet.field=Memory_s&facet.field=Video+Card_s&wt=ruby&facet.query=Memo

Re: Facet query pb

2009-10-11 Thread clico
clico wrote: > > > clico wrote: >> >> >> >> clico wrote: >>> >>> That's not a pb >>> I want to use that in order to drill down a tree >>> >>> >>> Christian Zambrano wrote: Clico, Because you are doing a wildcard query, the token 'AMERICA' will not be analyzed

Re: Facet query pb

2009-10-08 Thread clico
clico wrote: > > > > clico wrote: >> >> That's not a pb >> I want to use that in order to drill down a tree >> >> >> Christian Zambrano wrote: >>> >>> Clico, >>> >>> Because you are doing a wildcard query, the token 'AMERICA' will not be >>> analyzed at all. This means that 'AMERICA*' w

Re: Facet query pb

2009-10-08 Thread clico
clico wrote: > > That's not a pb > I want to use that in order to drill down a tree > > > Christian Zambrano wrote: >> >> Clico, >> >> Because you are doing a wildcard query, the token 'AMERICA' will not be >> analyzed at all. This means that 'AMERICA*' will NOT match 'america'. >> >> On

Re: Facet query pb

2009-10-07 Thread clico
That's not a pb I want to use that in order to drill down a tree Christian Zambrano wrote: > > Clico, > > Because you are doing a wildcard query, the token 'AMERICA' will not be > analyzed at all. This means that 'AMERICA*' will NOT match 'america'. > > On 10/07/2009 12:30 PM, Avlesh Singh w

Re: Facet query pb

2009-10-07 Thread Todd Benge
Aq On 10/7/09, clico wrote: > > Hello > I have a pb trying to retrieve a tree with facet use > > I 've got a field location_field > Each doc in my index has a location_field > > Location field can be > continent/country/city > > > I have 2 queries: > > http://server/solr//select?fq=(location_

Re: Facet query pb

2009-10-07 Thread Christian Zambrano
Clico, Because you are doing a wildcard query, the token 'AMERICA' will not be analyzed at all. This means that 'AMERICA*' will NOT match 'america'. On 10/07/2009 12:30 PM, Avlesh Singh wrote: I have no idea what "pb" mean but this is what you probably want - fq=(location_field:(NORTH AMERICA

Re: Facet query pb

2009-10-07 Thread Avlesh Singh
I have no idea what "pb" mean but this is what you probably want - fq=(location_field:(NORTH AMERICA*)) Cheers Avlesh On Wed, Oct 7, 2009 at 10:40 PM, clico wrote: > > Hello > I have a pb trying to retrieve a tree with facet use > > I 've got a field location_field > Each doc in my index has a

Re: Facet query return zero hits if category facet value has 2 or more words (looks like space does not work)

2009-06-07 Thread Erik Hatcher
On Jun 6, 2009, at 9:52 PM, Thanh Doan wrote: webapp=/solr path=/select params={facet=true&fl=pk_i,score&facet.mincount=1&q=([*+TO+*]+AND+* cat2_facet:Top+Wear*)+AND+ (type_s:Item )&facet .limit =-1&facet.field=cat1_facet&facet.field=cat2_facet&qt=standard&wt=ruby} *hits=0* status=0 QTime=1

Re: Facet query return zero hits if category facet value has 2 or more words (looks like space does not work)

2009-06-06 Thread Thanh Doan
Hi Steve, No. My cat2_facet field does not have id number. In the 2 queries below... not sure why query 1 did not work and query 2 worked perfectly. 1) query 1 (should return 2 documents, but it did not work) webapp=/solr path=/select params={facet=true&fl=pk_i,score&facet.mincount=1&q=([*+TO+*

Re: Facet query return zero hits if category facet value has 2 or more words (looks like space does not work)

2009-06-05 Thread Stephen Weiss
Thanh, Do the categories have id numbers? What we do is we index the ID numbers of our tags and categories, and then on display we pull the real text out of the database. In our situation, since the tags and categories are multilingual, it's a lot easier than converting from English to

Re: Facet Query Results Issue

2009-03-20 Thread Erik Hatcher
On Mar 20, 2009, at 6:39 AM, dabboo wrote: this is my facet query. facet .field =productPrice_product_str_s&facet.query=productPrice_product_str_s: [0%20TO%20100] This is my query and these are results, I am getting: It is only returning results, which are having values started with 2, 3

Re: Facet Query (fq) and Query (q)

2008-11-24 Thread Erik Hatcher
First, terminology clarification. fq is *filter* query. facet.query is facet query. On Nov 24, 2008, at 9:55 AM, Jae Joo wrote: I am having some trouble to utilize the facet Query. As I know that the facet Query has better performance that simple query (q). The performance is (about?) t

Re: Facet Query

2008-04-12 Thread Shalin Shekhar Mangar
OTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Yonik > Seeley > Sent: Friday, April 11, 2008 1:36 PM > To: solr-user@lucene.apache.org > Cc: Norskog, Lance > Subject: Re: Facet Query > > On Fri, Apr 11, 2008 at 4:32 PM, Lance Norskog <[EMAIL PROTECTED]> > wrote: >

RE: Facet Query

2008-04-11 Thread Norskog, Lance
Subject: Re: Facet Query On Fri, Apr 11, 2008 at 4:32 PM, Lance Norskog <[EMAIL PROTECTED]> wrote: > What do facet queries do that is different from the regular query? > What is a use case where I would use a facet.query in addition to the regular query? It returns the number of document

Re: Facet Query

2008-04-11 Thread Lucas F. A. Teixeira
Exactly, It`s something like count(*) group by _your-field_ []s, Lucas   Lucas Frare de Avelar Teixeira Analista de Sistemas [EMAIL PROTECTED] Tel:  (11) 3522-7723 - Ramal: 4014

Re: Facet Query

2008-04-11 Thread Yonik Seeley
On Fri, Apr 11, 2008 at 4:32 PM, Lance Norskog <[EMAIL PROTECTED]> wrote: > What do facet queries do that is different from the regular query? What is > a use case where I would use a facet.query in addition to the regular query? It returns the number of documents that match the query AND the fa

Re: facet query counts

2007-06-14 Thread Kevin Osborn
oblem. - Original Message From: Yonik Seeley <[EMAIL PROTECTED]> To: solr-user@lucene.apache.org Sent: Thursday, June 14, 2007 5:30:04 PM Subject: Re: facet query counts A 32 bit float has about 7 decimal digits of precision, so your range queries actually do overlap since 40f

Re: facet query counts

2007-06-14 Thread Yonik Seeley
A 32 bit float has about 7 decimal digits of precision, so your range queries actually do overlap since 40f is exactly the same as 39f -Yonik On 6/14/07, Kevin Osborn <[EMAIL PROTECTED]> wrote: I have a large subset (47640) of my total index. Most of them (45335) have a single

Re: facet query counts

2007-06-14 Thread Mike Klaas
On 14-Jun-07, at 4:29 PM, Kevin Osborn wrote: I have a large subset (47640) of my total index. Most of them (45335) have a single field, which we will call Field1. Field1 is a sfloat. If my query restricts the resultset to my subset and I do a facet count on Field1, then the number of rec