Re: Suggestion on distinct/ group by for a field ?

[Erick Erickson]

Maybe pivot facets will do what you need? See:

https://cwiki.apache.org/confluence/display/solr/Faceting#Faceting-Pivot(DecisionTree)Faceting

Best,
Erick

On Mon, Feb 23, 2015 at 11:31 AM, Vishal Swaroop  wrote:
> Please suggest on how to get the distinct count for a field (name).
>
> Summary : I have data indexed in the following format
> category name value
> Cat1 A 1
> Cat1 A 2
> Cat1 B 3
> Cat1 B 4
>
> I tried getting the distinct "name" count... but it returns 4 records
> instaed of 2 (i.e. A, B)
> http://localhost:8081/solr/core_test/select?q=category:Cat1&fl=category,name&wt=json&indent=true&facet.mincount=1&facet=true
>
> In Oracle I can easily perform the distinct count using groop-by
> select c.cat, count(*distinct *i.name) from category c, itemname i, value v
> where v.item_id = i.id and i.cat_id = c.id and c.cat ='Cat1' *group by
> c.cat *
> Result:
> "Cat1" "2"
>
> Thanks

Suggestion on distinct/ group by for a field ?

[Vishal Swaroop]

Please suggest on how to get the distinct count for a field (name).

Summary : I have data indexed in the following format
category name value
Cat1 A 1
Cat1 A 2
Cat1 B 3
Cat1 B 4

I tried getting the distinct "name" count... but it returns 4 records
instaed of 2 (i.e. A, B)
http://localhost:8081/solr/core_test/select?q=category:Cat1&fl=category,name&wt=json&indent=true&facet.mincount=1&facet=true

In Oracle I can easily perform the distinct count using groop-by
select c.cat, count(*distinct *i.name) from category c, itemname i, value v
where v.item_id = i.id and i.cat_id = c.id and c.cat ='Cat1' *group by
c.cat *
Result:
"Cat1" "2"

Thanks