[
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: [email protected]
For additional commands, e-mail: [email protected]
