Re: Solr facet order same as result set

2020-04-20 Thread Chris Hostetter
ml#child-childdoctransformerfactory https://lucene.apache.org/solr/guide/8_5/transforming-result-documents.html#subquery : Date: Mon, 20 Apr 2020 04:37:06 -0700 (MST) : From: Venu : Reply-To: solr-user@lucene.apache.org : To: solr-user@lucene.apache.org : Subject: Re: Solr facet order same as

Re: Solr facet order same as result set

2020-04-20 Thread Venu
Probably I haven't framed my question properly. Consider the schema with the fields - id, sku, fc_id, group_id The same SKU can be part of multiple documents with different fc_id and group_id. For a given search query, multiple documents having the same SKU will be returned. Is there any way I ca

Re: Solr facet order same as result set

2020-04-20 Thread Erick Erickson
I have no idea what “getting the facets in the same order as the sort docs” would mean. Even in the single-valued case, say idrankvalue_in_facet_field doc1 1 32 doc2 2 76 doc3 33 doc4 4 76 How would facets be or

Re: Solr facet on facet field returns junk values

2018-05-16 Thread Mikhail Khludnev
https://lucene.apache.org/solr/guide/6_6/faceting.html#Faceting-Thefacet.mincountParameter On Wed, May 16, 2018 at 1:41 PM, Srinivas Kashyap < srini...@tradestonesoftware.com> wrote: > Hello, > > I have a Solr collection which has around 20 fields(indexed and stored). > When I turn on facet and m

Re: [Solr facet distinct count] Benchmark and implementation details

2016-09-13 Thread Alessandro Benedetti
After a bit of investigation, I am verifying I get over the double of qTime for a single solr query on a distributed evnironment. I will go into the details, but before I go into the code, is the unique functionality going to be helped if we store docValues for the unique field ? I have a cardinal

Re: Solr - facet fields that contain other facet fields

2015-12-31 Thread Kevin Lopez
Hi Erick, I believe I have found a solution and I am putting plenty of detail for future reference. I have taken your previous advice and decided to add a field (cancerTerms) and add in the terms there. But I am not doing this outside of Solr. I am using the analysis chain and passing it through a

Re: Solr - facet fields that contain other facet fields

2015-12-29 Thread Erick Erickson
Sorry, I overlooked the ShingleFilterFactory. You're getting that from, presumably, your ShingleFilterFactory. Note that the minShingleSize=2 does not mean that only 2-shingles are output, there's yet another parameter "outputUnigrams" that controls that in combination with outputUnigramsIfNoShingl

Re: Solr - facet fields that contain other facet fields

2015-12-29 Thread Kevin Lopez
Erick, I am not sure when you say "the only available terms are "not" and "necessarily"" is totally correct. I go into the schema browser and I can see that there are two terms "not" and "not necessarily" with the correct count. Unless these are not the terms you are talking about. Can you explain

Re: Solr - facet fields that contain other facet fields

2015-12-28 Thread Erick Erickson
bq: so I cannot copy this field to a text field with a keywordtokenizer or strfield 1> There is no restriction on whether a field is analyzed or not as far as faceting is concerned. You can freely facet on an analyzed field or String field or KeywordTokenized field. As Binoy says, though, facetin

Re: Solr - facet fields that contain other facet fields

2015-12-28 Thread Binoy Dalal
1) When faceting use field of type string. That'll rid you of your tokenization problems. Alternatively do not use any tokenizers. Also turn doc values on for the field. It'll improve performance. 2) If however you do need to use a tokenized field for faceting, make sure that they're pretty short i

Re: Solr - facet fields that contain other facet fields

2015-12-28 Thread Kevin Lopez
I am not sure I am following correctly. The field I upload the document to would be "content" the analyzed field is "ColonCancerField". The "content" field contains the entire text of the document, in my case a pubmed abstract. This is a tokenized field. I made this field untokenized and I still re

Re: Solr - facet fields that contain other facet fields

2015-12-28 Thread Jamie Johnson
Can you do the opposite? Index into an unanalyzed field and copy into the analyzed? If I remember correctly facets are based off of indexed values so if you tokenize the field then the facets will be as you are seeing now. On Dec 28, 2015 9:45 AM, "Kevin Lopez" wrote: > *What I am trying to acc

Re: Solr facet query(critical solr query response)

2015-11-04 Thread Alessandro Benedetti
I suggest you to take a look to Yonik blog and in particular to the new Json Faceting approach and Nested document modelling. Hope this can help : http://yonik.com/solr-nested-objects/ ( nested objects ) http://yonik.com/json-facet-api/ ( nested facets) Cheers On 4 November 2015 at 12:15, Mugee

Re: Solr facet query(critical solr query response)

2015-11-04 Thread Mugeesh Husain
Thanks Erik >>Shouldn't td have s2=1 also? yes was my mistake I have also a search concern I have a 3 table Resturant, Review,User retuarant-[restid, restname,location...] User-[userid, uname,] Review-[reviewID, userid,restid,comment...] I am searching based on restaurant, how could i will

Re: Solr facet query(critical solr query response)

2015-11-04 Thread Erik Hatcher
Shouldn't td have s2=1 also? Try this: facet.pivot=vi,vk > On Nov 4, 2015, at 03:23, Mugeesh Husain wrote: > > i am facing issue of how to get below response from solr query. > > In my table, i have a two column vi and vk which has below values: > > row1: vi:["ta"] ,vk:["s1"] > row2:

Re: Solr facet search improvements

2015-01-28 Thread Jack Krupansky
It would probably be better to do entity extraction and normalization of job titles as a front-end process before ingesting the data into Solr, but you could also do it as a custom or script update processor. The latter can be easily coded in JavaScript to run within Solr Your first step in any ca

Re: Solr facet search improvements

2015-01-28 Thread Shawn Heisey
On 1/28/2015 3:56 AM, thakkar.aayush wrote: > I have around 1 million job titles which are indexed on Solr and am looking > to improve the faceted search results on job title matches. > > For example: a job search for *Research Scientist Computer Architecture* is > made, and the facet field title

Re: Solr facet field counts not correct

2013-10-23 Thread dboychuck
Hoss created: https://issues.apache.org/jira/browse/SOLR-5383 -- View this message in context: http://lucene.472066.n3.nabble.com/Solr-facet-field-counts-not-correct-tp4097305p4097346.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Solr facet field counts not correct

2013-10-23 Thread Chris Hostetter
: if I do group=false&group.facet=false the counts are what they should be for : the ungrouped counts... seems like group.facet isn't working correctly yeah ... thanks for digging int -- definitely seems like a problem with group.facet and Trie fields that use precisionStep. I've opened a Jira:

Re: Solr facet field counts not correct

2013-10-23 Thread dboychuck
if I do group=false&group.facet=false the counts are what they should be for the ungrouped counts... seems like group.facet isn't working correctly -- View this message in context: http://lucene.472066.n3.nabble.com/Solr-facet-field-counts-not-correct-tp4097305p4097314.html Sent from the Solr -

Re: Solr facet field counts not correct

2013-10-23 Thread dboychuck
Here is my query String: /solr/singleproductindex/productQuery?fq=siteid:82&q=categories_82_is:109124&facet=true&facet.query=HeatingArea_numeric:[0%20TO%20*]&facet.field=HeatingArea_numeric&debugQuery=true Here is my schema for that field: Here is my request handler definition:

Re: solr facet query on multiple search term

2013-06-11 Thread Chris Hostetter
: Actual requirement is to get day wise total no. of counts for multiple : terms. the approach you described in your original mail (using multiple fqs to identify your terms, and using multiple facet.range requests on the date field with differnet exclusions) will work fine. the confusing part

Re: solr facet query on multiple search term

2013-06-10 Thread Erick Erickson
There's nothing like that built in that I know of, the closest in concept is "pivot faceting" but that doesn't work in this case. Best Erick On Mon, Jun 10, 2013 at 2:13 AM, vrparekh wrote: > Thanks Erick, > > yes example url i provided is bit confusing, sorry for that. > > Actual requirement is

Re: solr facet query on multiple search term

2013-06-09 Thread vrparekh
Thanks Erick, yes example url i provided is bit confusing, sorry for that. Actual requirement is to get day wise total no. of counts for multiple terms. if we use q=(firstterm OR secondterm)&facet.query=firstterm&facet.query=secondTerm. It will provide total no. of records count for both search

Re: solr facet query on multiple search term

2013-06-07 Thread Erick Erickson
I'm a little confused here. Faceting is about counting docs that meet your query restrictions. I.e. the "q=" and "fq=" clauses. So your original problem statement simply cannot be combined into a single query since your q= clauses are different. You could do something like q=(firstterm OR secondter

Re: solr facet !tag on multiple columns

2012-10-04 Thread Chris Hostetter
: select?q=*:*&facet=true&facet.zeros=false&fq=column1:(16 31)&&fq=COLUMN2:(6 : 208)&fq={!tag=COLUMN2,column1}COLUMN2:(6)&facet.field={!ex=COLUMN2,column1}COLUMN2&start=0&rows=0 As erick said, you need to elaborate more on what you expect, what you get, and how they are differnet. taking a wil

Re: solr facet !tag on multiple columns

2012-10-04 Thread Erick Erickson
_how_ is it not working? You might review: http://wiki.apache.org/solr/UsingMailingLists Best Erick On Thu, Oct 4, 2012 at 4:37 AM, lavesh wrote: > select?q=*:*&facet=true&facet.zeros=false&fq=column1:(16 31)&&fq=COLUMN2:(6 > 208)&fq={!tag=COLUMN2,column1}COLUMN2:(6)&facet.field={!ex=COLUMN2,col

Re: solr facet !tag on multiple columns

2012-10-03 Thread Yonik Seeley
On Wed, Oct 3, 2012 at 11:04 AM, lavesh wrote: > I know this is possible in Solr which do the grouping irrespective of one > values. i.e below line do the grouping based on column1 considering all > filters except the column column1 > > &facet.field={!ex=column1}column1 > > now i wana know can i d

Re: Solr facet multiple constraint

2012-07-20 Thread Erick Erickson
NP, glad it's working for you! On Fri, Jul 20, 2012 at 8:26 AM, davidbougearel wrote: > I have tried and it works ! > > Thanks again a lot for this dude ! > > Regards, > David. > > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/Solr-facet-multiple-constraint-tp399297

Re: Solr facet multiple constraint

2012-07-20 Thread davidbougearel
I have tried and it works ! Thanks again a lot for this dude ! Regards, David. -- View this message in context: http://lucene.472066.n3.nabble.com/Solr-facet-multiple-constraint-tp3992974p3996189.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Solr facet multiple constraint

2012-07-20 Thread davidbougearel
Ok it's nice a facet query, i will try this feature and will reply you but i think that's the point, thanks a lot for time spent :) -- View this message in context: http://lucene.472066.n3.nabble.com/Solr-facet-multiple-constraint-tp3992974p3996186.html Sent from the Solr - User mailing list ar

Re: Solr facet multiple constraint

2012-07-17 Thread Erick Erickson
OK, maybe I'm finally getting it. When you do a facet.field=blahblah, you're telling Solr to take all the documents that match the query, look in field blahblah, and tally the documents that match _any_ value in the field. There's no restriction at all on the _values_ that that tally is made for.

Re: Solr facet multiple constraint

2012-07-16 Thread davidbougearel
Ok i'm added the debug, there is the query from the response after executing query : facet=true,sort=publishingdate desc,debugQuery=true,facet.mincount=1,q=service:1 AND publicationstatus:LIVE,facet.field=pillar,wt=javabin,fq=(((pillar:10))),version=2}},response={numFound=2,start=0,docs=[SolrDocum

Re: Solr facet multiple constraint

2012-07-14 Thread Erick Erickson
What do you get when you attach &debugQuery=on? That should show you the parsed query. You might paste that. Erick On Fri, Jul 13, 2012 at 1:14 AM, davidbougearel wrote: > Ok well i know about the complexity that i can put into fq with AND and OR > conditions but at the moment when i put fq=user

Re: Solr facet multiple constraint

2012-07-12 Thread davidbougearel
Ok well i know about the complexity that i can put into fq with AND and OR conditions but at the moment when i put fq=user:10,facet.field=user, the query returns me all the facets not taking into account the fq=user:10 that's the problem. -- View this message in context: http://lucene.472066.n3.n

Re: Solr facet multiple constraint

2012-07-12 Thread Erick Erickson
Sure, you can have as complex an FQ clause as you need. Best Erick On Thu, Jul 12, 2012 at 1:48 AM, davidbougearel wrote: > Ok this is the id but in fact (sorry about this) my wish is the reverse, i > want to get just the facet for which a have the right so i want to put > fq=user:10 in order to

Re: Solr facet multiple constraint

2012-07-11 Thread davidbougearel
Ok this is the id but in fact (sorry about this) my wish is the reverse, i want to get just the facet for which a have the right so i want to put fq=user:10 in order to get only facet with user:10. In my fq i can have something like user:10 AND user:3 because it's auto generated by rights of my ap

Re: Solr facet multiple constraint

2012-07-11 Thread Erick Erickson
OK, would it work just add an fq clause fq=-user:10? Or, depending on your Solr, fq=*:* -user:10? Best Erick On Tue, Jul 10, 2012 at 5:45 AM, davidbougearel wrote: > Ok sorry to not be clear and thanks again for your answers. > > q=service%3A1+AND+publicationstatus%3ALIVE&sort=publishingdate+des

Re: Solr facet multiple constraint

2012-07-10 Thread davidbougearel
Ok sorry to not be clear and thanks again for your answers. q=service%3A1+AND+publicationstatus%3ALIVE&sort=publishingdate+desc&fq=%7B%21ex%3Ddt%7D%28%28%28user%3A10%29%29%29&facet.field=%7B%21tag%3Ddt%7Duser&facet=true&facet.mincount=1 Here with this query i want to get all the documents (the el

Re: Solr facet multiple constraint

2012-07-09 Thread Erick Erickson
You still haven't given a clear (at least to me) statement of what you see and what about it isn't what you expect. Please give some concrete examples. Best Erick On Mon, Jul 9, 2012 at 3:45 AM, davidbougearel wrote: > Thanks for answer, > > Actually when i put 'it's not working' it means that i

Re: Solr facet multiple constraint

2012-07-09 Thread davidbougearel
Thanks for answer, Actually when i put 'it's not working' it means that it's not the result expected : the result return me data tagged by all the facets not only the facet that i ask for with the constraint. Hope you will help me. Best regards, David. -- View this message in context: http://

Re: solr facet fields doesn't honor fq

2012-07-08 Thread Erick Erickson
Solr faceting only counts documents that satisfy the query. Think of it as assembling a list of all possible values for a field and then adding 1 for each value found in each document that satisfies the overall query (including the filter query). So you can get counts of 0, that's expected. Adding

Re: Solr facet multiple constraint

2012-07-06 Thread Erick Erickson
What does "doesn't work" mean? returning no results? Not returning facets? returning incorrect facet counts? You might review: http://wiki.apache.org/solr/UsingMailingLists Best Erick On Fri, Jul 6, 2012 at 1:37 AM, davidbougearel wrote: > Well thanks for your answer, in fact i've written what

Re: Solr facet multiple constraint

2012-07-05 Thread davidbougearel
Well thanks for your answer, in fact i've written what the QueryResponse return as the solr query here is my real solr query before use the executeQuery : q=service%3A1+AND+publicationstatus%3ALIVE&sort=publishingdate+desc&fq=%7B%21ex%3Ddt%7D%28%28%28user%3A10%29%29%29&facet.field=%7B%21tag%3Ddt%7

Re: Solr facet multiple constraint

2012-07-05 Thread Erick Erickson
Well, to start with this query is totally messed up. facet=true,sort=publishingdate desc,facet.mincount=1,q=service:1 AND publicationstatus:LIVE,facet.field={!ex=dt}user,wt=javabin,fq={!tag=dt}user:10,version=2 You've put in commas where you should have ampersands to separate parameters=value pai

Re: Solr facet multiple constraint

2012-07-04 Thread davidbougearel
Please someone can help me, we are a team waiting for a fix. We try several ways to implement it without success. Thanks for reading anyway, David. -- View this message in context: http://lucene.472066.n3.nabble.com/Solr-facet-multiple-constraint-tp3992974p3993119.html Sent from the Solr - Use

Re: solr facet

2007-10-31 Thread Chris Hostetter
: I would like to use solr facets with multi-word queries, is it possible : I mainly implement a suggest application and use facet.prefix parameter, : it works fine with single word but not with multiple words it depends on your definition of "works" ? .. do you want each word to be a seperate