Re: Facet pivot 50.000.000 different values

2013-05-23 Thread Carlos Bonilla
In case anyone is interested, I solved my problem using the "grouping" feature: *query* --> "filter" query (if any) *field* --> field that you want to count (in my case field "B") SolrQuery solrQuery = new SolrQuery(query); solrQuery.add("group", "true"); solrQuery.add("group.field", "B"); // Gro

Re: Facet pivot 50.000.000 different values

2013-05-18 Thread Carlos Bonilla
Hi Mikhail, yes the thing is that I need to take into account different queries and that's why I can't use the Terms Component. Cheers. 2013/5/17 Mikhail Khludnev > On Fri, May 17, 2013 at 12:47 PM, Carlos Bonilla > wrote: > > > We > > only need to calculate how many different "B" values have

Re: Facet pivot 50.000.000 different values

2013-05-17 Thread Mikhail Khludnev
On Fri, May 17, 2013 at 12:47 PM, Carlos Bonilla wrote: > We > only need to calculate how many different "B" values have more than 1 > document but it takes ages > Carlos, It's not clear whether you need to take results of a query into account or just gather statistics from index. if later you ca

Re: Facet pivot 50.000.000 different values

2013-05-17 Thread Shawn Heisey
On 5/17/2013 2:47 AM, Carlos Bonilla wrote: > To calculate some stats we are using a field "B" with 50.000. different > values as facet pivot in a schema that contains 200.000.000 documents. We > only need to calculate how many different "B" values have more than 1 > document but it takes ages.

Re: Facet pivot 50.000.000 different values

2013-05-17 Thread Carlos Bonilla
Sorry, 16 GB RAM (not 8). 2013/5/17 Carlos Bonilla > Hi, > To calculate some stats we are using a field "B" with 50.000. > different values as facet pivot in a schema that contains 200.000.000 > documents. We only need to calculate how many different "B" values have > more than 1 document b

Facet pivot 50.000.000 different values

2013-05-17 Thread Carlos Bonilla
Hi, To calculate some stats we are using a field "B" with 50.000. different values as facet pivot in a schema that contains 200.000.000 documents. We only need to calculate how many different "B" values have more than 1 document but it takes ages Is there any other better way/configuration