[ https://issues.apache.org/jira/browse/SOLR-2242?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bill Bell updated SOLR-2242: ---------------------------- Description: When returning facet.field=<name of field> you will get a list of matches for distinct values. This is normal behavior. This patch tells you how many distinct values you have (# of rows). Use with limit=-1 and mincount=1. The feature is called "namedistinct". Here is an example: http://localhost:8983/solr/select?q=*:*&facet=true&facet.field=manu&facet.mincount=1&facet.limit=-1&f.manu.facet.namedistinct=0&facet.field=price&f.price.facet.namedistinct=1 Here is an example on field "hgid" (without namedistinct): {code} - <lst name="facet_fields"> - <lst name="hgid"> <int name="HGPY0000045FD36D4000A">1</int> <int name="HGPY00000FBC6690453A9">1</int> <int name="HGPY00001E44ED6C4FB3B">1</int> <int name="HGPY00001FA631034A1B8">1</int> <int name="HGPY00003317ABAC43B48">1</int> <int name="HGPY00003A17B2294CB5A">5</int> <int name="HGPY00003ADD2B3D48C39">1</int> </lst> </lst> {code} With namedistinct (HGPY0000045FD36D4000A, HGPY00000FBC6690453A9, HGPY00001E44ED6C4FB3B, HGPY00001FA631034A1B8, HGPY00003317ABAC43B48, HGPY00003A17B2294CB5A, HGPY00003ADD2B3D48C39). This returns number of rows (7), not the number of values (11). {code} - <lst name="facet_fields"> - <lst name="hgid"> <int name="_count_">7</int> </lst> </lst> {code} This works actually really good to get total number of fields for a group.field=hgid. Enjoy! was: When returning facet.field=<name of field> you will get a list of matches for distinct values. This is normal behavior. This patch tells you how many distinct values you have (# of rows). Use with limit=-1 and mincount=1. The feature is called "namedistinct". Here is an example: http://localhost:8983/solr/select?q=*:*&facet=true&facet.field=manu&facet.mincount=1&facet.limit=-1&f.manu.facet.namedistinct=0&facet.field=price&f.price.facet.namedistinct=1 Here is an example on field "hgid" (without namedistinct): - <lst name="facet_fields"> - <lst name="hgid"> <int name="HGPY0000045FD36D4000A">1</int> <int name="HGPY00000FBC6690453A9">1</int> <int name="HGPY00001E44ED6C4FB3B">1</int> <int name="HGPY00001FA631034A1B8">1</int> <int name="HGPY00003317ABAC43B48">1</int> <int name="HGPY00003A17B2294CB5A">5</int> <int name="HGPY00003ADD2B3D48C39">1</int> </lst> </lst> With namedistinct (HGPY0000045FD36D4000A, HGPY00000FBC6690453A9, HGPY00001E44ED6C4FB3B, HGPY00001FA631034A1B8, HGPY00003317ABAC43B48, HGPY00003A17B2294CB5A, HGPY00003ADD2B3D48C39). This returns number of rows (7), not the number of values (11). - <lst name="facet_fields"> - <lst name="hgid"> <int name="_count_">7</int> </lst> </lst> This works actually really good to get total number of fields for a group.field=hgid. Enjoy! > Get distinct count of names for a facet field > --------------------------------------------- > > Key: SOLR-2242 > URL: https://issues.apache.org/jira/browse/SOLR-2242 > Project: Solr > Issue Type: New Feature > Components: Response Writers > Affects Versions: 4.0 > Reporter: Bill Bell > Priority: Minor > Fix For: 4.0 > > Attachments: SOLR-2242-distinctFacet.patch > > > When returning facet.field=<name of field> you will get a list of matches for > distinct values. This is normal behavior. This patch tells you how many > distinct values you have (# of rows). Use with limit=-1 and mincount=1. > The feature is called "namedistinct". Here is an example: > http://localhost:8983/solr/select?q=*:*&facet=true&facet.field=manu&facet.mincount=1&facet.limit=-1&f.manu.facet.namedistinct=0&facet.field=price&f.price.facet.namedistinct=1 > Here is an example on field "hgid" (without namedistinct): > {code} > - <lst name="facet_fields"> > - <lst name="hgid"> > <int name="HGPY0000045FD36D4000A">1</int> > <int name="HGPY00000FBC6690453A9">1</int> > <int name="HGPY00001E44ED6C4FB3B">1</int> > <int name="HGPY00001FA631034A1B8">1</int> > <int name="HGPY00003317ABAC43B48">1</int> > <int name="HGPY00003A17B2294CB5A">5</int> > <int name="HGPY00003ADD2B3D48C39">1</int> > </lst> > </lst> > {code} > With namedistinct (HGPY0000045FD36D4000A, HGPY00000FBC6690453A9, > HGPY00001E44ED6C4FB3B, HGPY00001FA631034A1B8, HGPY00003317ABAC43B48, > HGPY00003A17B2294CB5A, HGPY00003ADD2B3D48C39). This returns number of rows > (7), not the number of values (11). > {code} > - <lst name="facet_fields"> > - <lst name="hgid"> > <int name="_count_">7</int> > </lst> > </lst> > {code} > This works actually really good to get total number of fields for a > group.field=hgid. Enjoy! -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org