[jira] [Issue Comment Edited] (SOLR-2242) Get distinct count of names for a facet field
[
https://issues.apache.org/jira/browse/SOLR-2242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13191185#comment-13191185
]
Ethan Gruber edited comment on SOLR-2242 at 1/23/12 2:50 PM:
-
+1 for me too. I have been using this feature for almost a year. I plan to
upgrade to the newest patch/Solr trunk code, but the patch doesn't apply to the
current trunk. Do I have to check out the revision that dates to 12/21/11 to
get this to work?
edit: nevermind, the answer is yes. I had to check out revision 1221500 from
Dec. 20.
was (Author: ewg118):
+1 for me too. I have been using this feature for almost a year. I plan
to upgrade to the newest patch/Solr trunk code, but the patch doesn't apply to
the current trunk. Do I have to check out the revision that dates to 12/21/11
to get this to work?
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
Assignee: Erick Erickson
Priority: Minor
Fix For: 4.0
Attachments: NumFacetTermsFacetsTest.java,
SOLR-2242-notworkingtest.patch, SOLR-2242.patch, SOLR-2242.patch,
SOLR-2242.patch, SOLR-2242.shard.patch, SOLR-2242.shard.patch,
SOLR-2242.shard.withtests.patch, SOLR-2242.solr3.1-fix.patch,
SOLR-2242.solr3.1.patch, SOLR.2242.solr3.1.patch, SOLR.2242.v2.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?shards=localhost:8983/solr,localhost:7574/solrindent=trueq=*:*facet=truefacet.mincount=1facet.numFacetTerms=2facet.limit=-1facet.field=price
http://localhost:8983/solr/select?shards=localhost:8983/solr,localhost:7574/solrindent=trueq=*:*facet=truefacet.mincount=1facet.numFacetTerms=0facet.limit=-1facet.field=price
http://localhost:8983/solr/select?shards=localhost:8983/solr,localhost:7574/solrindent=trueq=*:*facet=truefacet.mincount=1facet.numFacetTerms=1facet.limit=-1facet.field=price
This currently only works on facet.field.
{code}
lst name=facet_fields
lst name=price
int name=numFacetTerms14/int
int name=0.03/intint name=11.51/intint
name=19.951/intint name=74.991/intint name=92.01/intint
name=179.991/intint name=185.01/intint name=279.951/intint
name=329.951/intint name=350.01/intint name=399.01/intint
name=479.951/intint name=649.991/intint name=2199.01/int
/lst
/lst
{code}
Several people use this to get the group.field count (the # of groups).
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Issue Comment Edited] (SOLR-2242) Get distinct count of names for a facet field
[
https://issues.apache.org/jira/browse/SOLR-2242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13174739#comment-13174739
]
Antoine Le Floc'h edited comment on SOLR-2242 at 12/22/11 10:57 AM:
To help with the specification, my use case is this: I am using this patch and
possibly want to add extra infos in the facet results, and want to use
sharding... Basically, this is what I have today with the patch:
lst name=shop_id
int name=numTerms10251/int
lst name=counts
int name=280137567032406/int
int name=280095893616625/int
int name=9763497825/int
int name=6351398780/int
int name=28021713440118/int
int name=29047336368921/int
int name=411244689/int
/lst
/lst
and I want to subclass/modify SimpleFacets to add more data for each item
(since I don't see other way to do it)
was (Author: alefloch):
I am using this patch and possibly want to add extra infos in the facet
results, and want to use sharding... Is there an associated patch to fix
sharding ? Is it an easy fix ? Is this working out of the box in 4.0 ? Thank
you.
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
Assignee: Erick Erickson
Priority: Minor
Fix For: 4.0
Attachments: NumFacetTermsFacetsTest.java,
SOLR-2242-notworkingtest.patch, SOLR-2242.patch, SOLR-2242.patch,
SOLR-2242.patch, SOLR-2242.shard.patch, SOLR-2242.shard.patch,
SOLR-2242.shard.withtests.patch, SOLR-2242.solr3.1-fix.patch,
SOLR-2242.solr3.1.patch, SOLR.2242.solr3.1.patch, SOLR.2242.v2.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?shards=localhost:8983/solr,localhost:7574/solrindent=trueq=*:*facet=truefacet.mincount=1facet.numFacetTerms=2facet.limit=-1facet.field=price
http://localhost:8983/solr/select?shards=localhost:8983/solr,localhost:7574/solrindent=trueq=*:*facet=truefacet.mincount=1facet.numFacetTerms=0facet.limit=-1facet.field=price
http://localhost:8983/solr/select?shards=localhost:8983/solr,localhost:7574/solrindent=trueq=*:*facet=truefacet.mincount=1facet.numFacetTerms=1facet.limit=-1facet.field=price
This currently only works on facet.field.
{code}
lst name=facet_fields
lst name=price
int name=numFacetTerms14/int
int name=0.03/intint name=11.51/intint
name=19.951/intint name=74.991/intint name=92.01/intint
name=179.991/intint name=185.01/intint name=279.951/intint
name=329.951/intint name=350.01/intint name=399.01/intint
name=479.951/intint name=649.991/intint name=2199.01/int
/lst
/lst
{code}
Several people use this to get the group.field count (the # of groups).
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Issue Comment Edited] (SOLR-2242) Get distinct count of names for a facet field
[
https://issues.apache.org/jira/browse/SOLR-2242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13174739#comment-13174739
]
Antoine Le Floc'h edited comment on SOLR-2242 at 12/22/11 11:02 AM:
To help with the specification, my use case is this: I am using this patch and
possibly want to add extra infos in the facet results, and want to use
sharding... Basically, this is what I have today with the patch:
{code}
lst name=shop_id
int name=numTerms10251/int
lst name=counts
int name=280137567032406/int
int name=280095893616625/int
int name=9763497825/int
int name=6351398780/int
int name=28021713440118/int
int name=29047336368921/int
int name=411244689/int
/lst
/lst
{code}
and I want to subclass/modify SimpleFacets to add more data for each item
(since I don't see other way to do it)
was (Author: alefloch):
To help with the specification, my use case is this: I am using this patch
and possibly want to add extra infos in the facet results, and want to use
sharding... Basically, this is what I have today with the patch:
lst name=shop_id
int name=numTerms10251/int
lst name=counts
int name=280137567032406/int
int name=280095893616625/int
int name=9763497825/int
int name=6351398780/int
int name=28021713440118/int
int name=29047336368921/int
int name=411244689/int
/lst
/lst
and I want to subclass/modify SimpleFacets to add more data for each item
(since I don't see other way to do it)
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
Assignee: Erick Erickson
Priority: Minor
Fix For: 4.0
Attachments: NumFacetTermsFacetsTest.java,
SOLR-2242-notworkingtest.patch, SOLR-2242.patch, SOLR-2242.patch,
SOLR-2242.patch, SOLR-2242.shard.patch, SOLR-2242.shard.patch,
SOLR-2242.shard.withtests.patch, SOLR-2242.solr3.1-fix.patch,
SOLR-2242.solr3.1.patch, SOLR.2242.solr3.1.patch, SOLR.2242.v2.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?shards=localhost:8983/solr,localhost:7574/solrindent=trueq=*:*facet=truefacet.mincount=1facet.numFacetTerms=2facet.limit=-1facet.field=price
http://localhost:8983/solr/select?shards=localhost:8983/solr,localhost:7574/solrindent=trueq=*:*facet=truefacet.mincount=1facet.numFacetTerms=0facet.limit=-1facet.field=price
http://localhost:8983/solr/select?shards=localhost:8983/solr,localhost:7574/solrindent=trueq=*:*facet=truefacet.mincount=1facet.numFacetTerms=1facet.limit=-1facet.field=price
This currently only works on facet.field.
{code}
lst name=facet_fields
lst name=price
int name=numFacetTerms14/int
int name=0.03/intint name=11.51/intint
name=19.951/intint name=74.991/intint name=92.01/intint
name=179.991/intint name=185.01/intint name=279.951/intint
name=329.951/intint name=350.01/intint name=399.01/intint
name=479.951/intint name=649.991/intint name=2199.01/int
/lst
/lst
{code}
Several people use this to get the group.field count (the # of groups).
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Issue Comment Edited] (SOLR-2242) Get distinct count of names for a facet field
[ https://issues.apache.org/jira/browse/SOLR-2242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13174152#comment-13174152 ] Erick Erickson edited comment on SOLR-2242 at 12/21/11 3:45 PM: OK, it seems like we have several themes here. I'd like to get a reasonable consensus before going forward... I'll put out a straw-man proposal here and we can go from there. But lets figure out where we're going before revamping stuff yet again. 1 Distributed support. I sure don't see a good way to support this currently. Perhaps some of the future enhancements will make this easier (thinking distributed TF/IDF such while being totally ignorant of that code), but returning the entire list of constraints (or names or terms or whatever we call it) is just a bad idea. The first time someone tries this on a field with 1,000,000 terms (yes, I've seen this) it'll just blow things up. I'm also slightly anti the min/max idea. I'm not sure what value there is in telling someone there are between 10,000 and 90,000 distinct values. And if it's a field with just a few pre-defined values, that information is already known anyway But if someone can show a use-case here I'm not completely against it. But I'd like to see the use case first, not someone might find it useful G. 2 back compat. Cody's suggestion seems to be the slickest in terms of not breaking things, but we use attributes in just a few places, are there reasons NOT to do it that way? Or does this mess up JSON, PHP, etc? 3 Possibly add a new JIRA for changing the facet response format to be tolerant of sub-fields, but don't do that here. Again, I want a clearly defined end point for the concerns raised before we dive back in here was (Author: erickerickson): OK, it seems like we have several themes here. I'd like to get a reasonable consensus before going forward... I'll put out a straw-man proposal here and we can go from there. But lets figure out where we're going before revamping stuff yet again. 1 Distributed support. I sure don't see a good way to support this currently. Perhaps some of the future enhancements will make this easier (thinking distributed TF/IDF such while being totally ignorant of that code), but returning the entire list of constraints (or names or terms or whatever we call it) is just a bad idea. The first time someone tries this on a field with 1,000,000 terms (yes, I've seen this) it'll just blow things up. I'm also slightly anti the min/max idea. I'm not sure what value there is in telling someone there are between 10,000 and 90,000 distinct values. And if it's a field with just a few pre-defined values, that information is already known anyway But if someone can show a use-case here I'm not completely against it. But I'd like to see the use case first, not someone might find it useful G. 2 back compat. Cody's suggestion seems to be the slickest in terms of not breaking things, but we use attributes in just a few places, are there reasons NOT to do it that way? 3 Possibly add a new JIRA for changing the facet response format to be tolerant of sub-fields, but don't do that here. Again, I want a clearly defined end point for the concerns raised before we dive back in here 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 Assignee: Erick Erickson Priority: Minor Fix For: 4.0 Attachments: NumFacetTermsFacetsTest.java, SOLR-2242-notworkingtest.patch, SOLR-2242.patch, SOLR-2242.patch, SOLR-2242.shard.patch, SOLR-2242.shard.patch, SOLR-2242.shard.withtests.patch, SOLR-2242.solr3.1-fix.patch, SOLR-2242.solr3.1.patch, SOLR.2242.solr3.1.patch, SOLR.2242.v2.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?shards=localhost:8983/solr,localhost:7574/solrindent=trueq=*:*facet=truefacet.mincount=1facet.numFacetTerms=2facet.limit=-1facet.field=price http://localhost:8983/solr/select?shards=localhost:8983/solr,localhost:7574/solrindent=trueq=*:*facet=truefacet.mincount=1facet.numFacetTerms=0facet.limit=-1facet.field=price http://localhost:8983/solr/select?shards=localhost:8983/solr,localhost:7574/solrindent=trueq=*:*facet=truefacet.mincount=1facet.numFacetTerms=1facet.limit=-1facet.field=price This currently only
[jira] [Issue Comment Edited] (SOLR-2242) Get distinct count of names for a facet field
[
https://issues.apache.org/jira/browse/SOLR-2242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13174441#comment-13174441
]
Erick Erickson edited comment on SOLR-2242 at 12/21/11 9:51 PM:
First step in resurrecting this. This patch should apply cleanly to trunk. It
incorporates the SOLR-2242.patch from 28-June and the NumFacetTermsFacetsTest
from 9-July. It accounts for the fact that things seem to have been moved
around a bit. All I guarantee is that the code compiles and the
NumFacetTermsFacetsTest runs from inside IntelliJ.
was (Author: erickerickson):
First step in resurrecting this. This patch should apply cleanly to trunk.
It incorporates the SOLR-2242.patch from 28-June and the
NumFacetTermsFacetsTest from 9-July. It accounts for the fact that things seem
to have been moved around a bit.
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
Assignee: Erick Erickson
Priority: Minor
Fix For: 4.0
Attachments: NumFacetTermsFacetsTest.java,
SOLR-2242-notworkingtest.patch, SOLR-2242.patch, SOLR-2242.patch,
SOLR-2242.patch, SOLR-2242.shard.patch, SOLR-2242.shard.patch,
SOLR-2242.shard.withtests.patch, SOLR-2242.solr3.1-fix.patch,
SOLR-2242.solr3.1.patch, SOLR.2242.solr3.1.patch, SOLR.2242.v2.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?shards=localhost:8983/solr,localhost:7574/solrindent=trueq=*:*facet=truefacet.mincount=1facet.numFacetTerms=2facet.limit=-1facet.field=price
http://localhost:8983/solr/select?shards=localhost:8983/solr,localhost:7574/solrindent=trueq=*:*facet=truefacet.mincount=1facet.numFacetTerms=0facet.limit=-1facet.field=price
http://localhost:8983/solr/select?shards=localhost:8983/solr,localhost:7574/solrindent=trueq=*:*facet=truefacet.mincount=1facet.numFacetTerms=1facet.limit=-1facet.field=price
This currently only works on facet.field.
{code}
lst name=facet_fields
lst name=price
int name=numFacetTerms14/int
int name=0.03/intint name=11.51/intint
name=19.951/intint name=74.991/intint name=92.01/intint
name=179.991/intint name=185.01/intint name=279.951/intint
name=329.951/intint name=350.01/intint name=399.01/intint
name=479.951/intint name=649.991/intint name=2199.01/int
/lst
/lst
{code}
Several people use this to get the group.field count (the # of groups).
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Issue Comment Edited] (SOLR-2242) Get distinct count of names for a facet field
[
https://issues.apache.org/jira/browse/SOLR-2242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13174441#comment-13174441
]
Erick Erickson edited comment on SOLR-2242 at 12/21/11 9:50 PM:
First step in resurrecting this. This patch should apply cleanly to trunk. It
incorporates the SOLR-2242.patch from 28-June and the NumFacetTermsFacetsTest
from 9-July. It accounts for the fact that things seem to have been moved
around a bit.
was (Author: erickerickson):
First step in resurrecting this. This patch should apply cleanly to trunk.
It incorporates the SOLR-2242.patch from 28-June and the NmFacetTermsFacetsTest
from 9-July. It accounts for the fact that things seem to have been moved
around a bit.
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
Assignee: Erick Erickson
Priority: Minor
Fix For: 4.0
Attachments: NumFacetTermsFacetsTest.java,
SOLR-2242-notworkingtest.patch, SOLR-2242.patch, SOLR-2242.patch,
SOLR-2242.patch, SOLR-2242.shard.patch, SOLR-2242.shard.patch,
SOLR-2242.shard.withtests.patch, SOLR-2242.solr3.1-fix.patch,
SOLR-2242.solr3.1.patch, SOLR.2242.solr3.1.patch, SOLR.2242.v2.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?shards=localhost:8983/solr,localhost:7574/solrindent=trueq=*:*facet=truefacet.mincount=1facet.numFacetTerms=2facet.limit=-1facet.field=price
http://localhost:8983/solr/select?shards=localhost:8983/solr,localhost:7574/solrindent=trueq=*:*facet=truefacet.mincount=1facet.numFacetTerms=0facet.limit=-1facet.field=price
http://localhost:8983/solr/select?shards=localhost:8983/solr,localhost:7574/solrindent=trueq=*:*facet=truefacet.mincount=1facet.numFacetTerms=1facet.limit=-1facet.field=price
This currently only works on facet.field.
{code}
lst name=facet_fields
lst name=price
int name=numFacetTerms14/int
int name=0.03/intint name=11.51/intint
name=19.951/intint name=74.991/intint name=92.01/intint
name=179.991/intint name=185.01/intint name=279.951/intint
name=329.951/intint name=350.01/intint name=399.01/intint
name=479.951/intint name=649.991/intint name=2199.01/int
/lst
/lst
{code}
Several people use this to get the group.field count (the # of groups).
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Issue Comment Edited] (SOLR-2242) Get distinct count of names for a facet field
[
https://issues.apache.org/jira/browse/SOLR-2242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13095135#comment-13095135
]
Nguyen Kien Trung edited comment on SOLR-2242 at 9/1/11 5:50 AM:
-
I'm using Solr 3.2. Instead of patching, I extend {{SimpleFacets}} and
{{FacetComponent}}, apply the changes mentioned in [^SOLR-2242.solr3.1.patch]
with a small fix ([^SOLR-2242.solr3.1-fix.patch]).
{code}
int offset = params.getFieldInt(facetValue, FacetParams.FACET_OFFSET, 0);
resCount.add(numTerms, counts.size() + offset);
{code}
as {{counts}} contains list of terms started from the given {{offset}}
It accepts param {{facet.numTerms=true|false}} and produce the output
{code}
lst name=facet_fields
lst name=color
int name=numTerms124/int
lst name=counts /
int name=red4/int
int name=blue3/int
/lst
/lst
/lst
{code}
Not yet tested with sharding
was (Author: trung):
I'm using Solr 3.2. Instead of patching, I extend {{SimpleFacets}} and
{{FacetComponent}}, apply the changes mentioned in [^SOLR-2242.solr3.1.patch]
with a small fix ([^SOLR\-2242.solr3.1-fix.patch]).
{code}
int offset = params.getFieldInt(facetValue, FacetParams.FACET_OFFSET, 0);
resCount.add(numTerms, counts.size() + offset);
{code}
as {{counts}} contains list of terms started from the given {{offset}}
It accepts param {{facet.numTerms=true|false}} and produce the output
{code}
lst name=facet_fields
lst name=color
int name=numTerms124/int
lst name=counts /
int name=red4/int
int name=blue3/int
/lst
/lst
/lst
{code}
Not yet tested with sharding
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
Assignee: Simon Willnauer
Priority: Minor
Fix For: 4.0
Attachments: NumFacetTermsFacetsTest.java,
SOLR-2242-notworkingtest.patch, SOLR-2242.patch, SOLR-2242.patch,
SOLR-2242.shard.patch, SOLR-2242.shard.patch,
SOLR-2242.shard.withtests.patch, SOLR-2242.solr3.1-fix.patch,
SOLR-2242.solr3.1.patch, SOLR.2242.solr3.1.patch, SOLR.2242.v2.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?shards=localhost:8983/solr,localhost:7574/solrindent=trueq=*:*facet=truefacet.mincount=1facet.numFacetTerms=2facet.limit=-1facet.field=price
http://localhost:8983/solr/select?shards=localhost:8983/solr,localhost:7574/solrindent=trueq=*:*facet=truefacet.mincount=1facet.numFacetTerms=0facet.limit=-1facet.field=price
http://localhost:8983/solr/select?shards=localhost:8983/solr,localhost:7574/solrindent=trueq=*:*facet=truefacet.mincount=1facet.numFacetTerms=1facet.limit=-1facet.field=price
This currently only works on facet.field.
{code}
lst name=facet_fields
lst name=price
int name=numFacetTerms14/int
int name=0.03/intint name=11.51/intint
name=19.951/intint name=74.991/intint name=92.01/intint
name=179.991/intint name=185.01/intint name=279.951/intint
name=329.951/intint name=350.01/intint name=399.01/intint
name=479.951/intint name=649.991/intint name=2199.01/int
/lst
/lst
{code}
Several people use this to get the group.field count (the # of groups).
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Issue Comment Edited] (SOLR-2242) Get distinct count of names for a facet field
[
https://issues.apache.org/jira/browse/SOLR-2242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13071156#comment-13071156
]
Chris Male edited comment on SOLR-2242 at 7/26/11 3:28 PM:
---
{quote}
That seems reasonable – though I think we would also want to be able to have
the sum when you know that all shards have unique values.
{quote}
Perhaps we should return the maximum and sum of all shard counts? That way,
assuming the client knew how many shards exist, they could handle most
scenarios.
{quote}
I don't think bill is referring to the accuracy/meaning of distinct count in
distributed search. His problem is that if we change the output format, we also
need to update the code that collects the various values and passes them along.
This patch just add a magic value (numFacetTerms) to the count list so that the
value is handled with existing distributed response parsing. This is a fine
one-off solution, but I am -1 for adding any more magic field names to solr. To
add this feature, i think we need to bite the bullet and update the facet
response format.
{quote}
Absolutely. I hadn't even considered the prospect of not changing the
distributed response parsing.
was (Author: cmale):
{code}
That seems reasonable – though I think we would also want to be able to have
the sum when you know that all shards have unique values.
{code}
Perhaps we should return the maximum and sum of all shard counts? That way,
assuming the client knew how many shards exist, they could handle most
scenarios.
{code}
I don't think bill is referring to the accuracy/meaning of distinct count in
distributed search. His problem is that if we change the output format, we also
need to update the code that collects the various values and passes them along.
This patch just add a magic value (numFacetTerms) to the count list so that the
value is handled with existing distributed response parsing. This is a fine
one-off solution, but I am -1 for adding any more magic field names to solr. To
add this feature, i think we need to bite the bullet and update the facet
response format.
{code}
Absolutely. I hadn't even considered the prospect of not changing the
distributed response parsing.
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
Assignee: Simon Willnauer
Priority: Minor
Fix For: 4.0
Attachments: NumFacetTermsFacetsTest.java,
SOLR-2242-notworkingtest.patch, SOLR-2242.patch, SOLR-2242.patch,
SOLR-2242.shard.patch, SOLR-2242.shard.patch,
SOLR-2242.shard.withtests.patch, SOLR-2242.solr3.1.patch,
SOLR.2242.solr3.1.patch, SOLR.2242.v2.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?shards=localhost:8983/solr,localhost:7574/solrindent=trueq=*:*facet=truefacet.mincount=1facet.numFacetTerms=2facet.limit=-1facet.field=price
http://localhost:8983/solr/select?shards=localhost:8983/solr,localhost:7574/solrindent=trueq=*:*facet=truefacet.mincount=1facet.numFacetTerms=0facet.limit=-1facet.field=price
http://localhost:8983/solr/select?shards=localhost:8983/solr,localhost:7574/solrindent=trueq=*:*facet=truefacet.mincount=1facet.numFacetTerms=1facet.limit=-1facet.field=price
This currently only works on facet.field.
{code}
lst name=facet_fields
lst name=price
int name=numFacetTerms14/int
int name=0.03/intint name=11.51/intint
name=19.951/intint name=74.991/intint name=92.01/intint
name=179.991/intint name=185.01/intint name=279.951/intint
name=329.951/intint name=350.01/intint name=399.01/intint
name=479.951/intint name=649.991/intint name=2199.01/int
/lst
/lst
{code}
Several people use this to get the group.field count (the # of groups).
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Issue Comment Edited] (SOLR-2242) Get distinct count of names for a facet field
[
https://issues.apache.org/jira/browse/SOLR-2242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13024966#comment-13024966
]
Lance Norskog edited comment on SOLR-2242 at 4/28/11 2:01 AM:
--
From the patch:
bq. {{public static final String FACET_NAMEDISTINCT = FACET +
.numFacetTerms;}}
So- in this issue, a _name_ is what everything else calls a _term_, and a
_value_ is what everyone else calls a _count of documents with *this term* in
*this field*_. Please change this in the patch.
was (Author: lancenorskog):
From the patch:
bq. {{public static final String FACET_NAMEDISTINCT = FACET +
.numFacetTerms;}}
So- in this issue, a _name_ is what everything else calls a _term_. Please
change this in the patch.
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.solr3.1.patch, SOLR.2242.v2.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=truefacet.field=manufacet.mincount=1facet.limit=-1f.manu.facet.namedistinct=0facet.field=pricef.price.facet.namedistinct=1
Here is an example on field hgid (without namedistinct):
{code}
- lst name=facet_fields
- lst name=hgid
int name=HGPY045FD36D4000A1/int
int name=HGPY0FBC6690453A91/int
int name=HGPY1E44ED6C4FB3B1/int
int name=HGPY1FA631034A1B81/int
int name=HGPY3317ABAC43B481/int
int name=HGPY3A17B2294CB5A5/int
int name=HGPY3ADD2B3D48C391/int
/lst
/lst
{code}
With namedistinct (HGPY045FD36D4000A, HGPY0FBC6690453A9,
HGPY1E44ED6C4FB3B, HGPY1FA631034A1B8, HGPY3317ABAC43B48,
HGPY3A17B2294CB5A, HGPY3ADD2B3D48C39). 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.
For more information on JIRA, see: http://www.atlassian.com/software/jira
-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Issue Comment Edited] (SOLR-2242) Get distinct count of names for a facet field
[
https://issues.apache.org/jira/browse/SOLR-2242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13026103#comment-13026103
]
Bill Bell edited comment on SOLR-2242 at 4/28/11 3:51 AM:
--
Lance Norskog,
What do you want it to be called? I would use a committer to take this issue
on. It has several votes, and lots of downloads. People are using it
successfully already.
Do you want me to switch the numFacetTerms to numFacetNames ? Anything else? I
feel like we are going in circles on this issue.
{code}
This will output the numFacetTerms AND hgid:
http://localhost:8983/solr/select?q=*:*facet=truefacet.field=hgidfacet.mincount=1f.hgid.facet.numFacetNames=2
lst name=facet_fields
lst name=hgid
int name=numFacetNames7/int !-- this is not 11 --
lst name=counts
int name=HGPY045FD36D4000A1/int
int name=HGPY0FBC6690453A91/int
int name=HGPY1E44ED6C4FB3B1/int
int name=HGPY1FA631034A1B81/int
int name=HGPY3317ABAC43B481/int
int name=HGPY3A17B2294CB5A5/int
int name=HGPY3ADD2B3D48C391/int
/lst
/lst
/lst
{code}
was (Author: billnbell):
Lance Norskog,
What do you want it to be called? I would use a committer to take this issue
on. It has several votes, and lots of downloads. People are using it
successfully already.
Do you want me to switch the numFacetTerms to numFacetNames ? Anything else? I
feel like we are going in circles on this issue.
{code}
This will output the numFacetTerms AND hgid:
http://localhost:8983/solr/select?q=*:*facet=truefacet.field=hgidfacet.mincount=1f.hgid.facet.numFacetTerms=2
lst name=facet_fields
lst name=hgid
int name=numFacetTerms7/int !-- this is not 11 --
lst name=counts
int name=HGPY045FD36D4000A1/int
int name=HGPY0FBC6690453A91/int
int name=HGPY1E44ED6C4FB3B1/int
int name=HGPY1FA631034A1B81/int
int name=HGPY3317ABAC43B481/int
int name=HGPY3A17B2294CB5A5/int
int name=HGPY3ADD2B3D48C391/int
/lst
/lst
/lst
{code}
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.patch, SOLR.2242.solr3.1.patch,
SOLR.2242.v2.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=truefacet.field=manufacet.mincount=1facet.limit=-1f.manu.facet.namedistinct=0facet.field=pricef.price.facet.namedistinct=1
Here is an example on field hgid (without namedistinct):
{code}
- lst name=facet_fields
- lst name=hgid
int name=HGPY045FD36D4000A1/int
int name=HGPY0FBC6690453A91/int
int name=HGPY1E44ED6C4FB3B1/int
int name=HGPY1FA631034A1B81/int
int name=HGPY3317ABAC43B481/int
int name=HGPY3A17B2294CB5A5/int
int name=HGPY3ADD2B3D48C391/int
/lst
/lst
{code}
With namedistinct (HGPY045FD36D4000A, HGPY0FBC6690453A9,
HGPY1E44ED6C4FB3B, HGPY1FA631034A1B8, HGPY3317ABAC43B48,
HGPY3A17B2294CB5A, HGPY3ADD2B3D48C39). 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.
For more information on JIRA, see: http://www.atlassian.com/software/jira
-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Issue Comment Edited] (SOLR-2242) Get distinct count of names for a facet field
[
https://issues.apache.org/jira/browse/SOLR-2242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13026124#comment-13026124
]
Lance Norskog edited comment on SOLR-2242 at 4/28/11 5:33 AM:
--
Putting up or shutting up :)
This splits apart whether to count terms v.s. whether to count docs per term.
They are independent concepts.
Instead of 'numFacetTerms=0/1/2' it is 'numTerms=true/false'.
if you set 'numTerms=true', it counts terms.
If you set facet.limit=0, it does not do the facet search. It does not count
docs per term.
If you set 'numTerms=false' and 'facet.limit=0', it does nothing.
And, everything is called 'facet' and 'term' :)
was (Author: lancenorskog):
Putting up or shutting up :)
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.patch, SOLR-2242.solr3.1.patch,
SOLR.2242.solr3.1.patch, SOLR.2242.v2.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=truefacet.field=manufacet.mincount=1facet.limit=-1f.manu.facet.namedistinct=0facet.field=pricef.price.facet.namedistinct=1
Here is an example on field hgid (without namedistinct):
{code}
- lst name=facet_fields
- lst name=hgid
int name=HGPY045FD36D4000A1/int
int name=HGPY0FBC6690453A91/int
int name=HGPY1E44ED6C4FB3B1/int
int name=HGPY1FA631034A1B81/int
int name=HGPY3317ABAC43B481/int
int name=HGPY3A17B2294CB5A5/int
int name=HGPY3ADD2B3D48C391/int
/lst
/lst
{code}
With namedistinct (HGPY045FD36D4000A, HGPY0FBC6690453A9,
HGPY1E44ED6C4FB3B, HGPY1FA631034A1B8, HGPY3317ABAC43B48,
HGPY3A17B2294CB5A, HGPY3ADD2B3D48C39). 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.
For more information on JIRA, see: http://www.atlassian.com/software/jira
-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Issue Comment Edited] (SOLR-2242) Get distinct count of names for a facet field
[
https://issues.apache.org/jira/browse/SOLR-2242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13026124#comment-13026124
]
Lance Norskog edited comment on SOLR-2242 at 4/28/11 5:33 AM:
--
Putting up or shutting up :)
This splits apart whether to count terms v.s. whether to count docs per term.
They are independent concepts.
Instead of 'numFacetTerms=0/1/2' it is 'numTerms=true/false'.
if you set 'numTerms=true', it counts terms.
If you set facet.limit=0, it does not do the facet search. It does not count
docs per term.
If you set 'numTerms=false' and 'facet.limit=0', it does nothing.
'numFacetTerms' is redundant- we know it's all about facets. Thus, 'numTerms'.
was (Author: lancenorskog):
Putting up or shutting up :)
This splits apart whether to count terms v.s. whether to count docs per term.
They are independent concepts.
Instead of 'numFacetTerms=0/1/2' it is 'numTerms=true/false'.
if you set 'numTerms=true', it counts terms.
If you set facet.limit=0, it does not do the facet search. It does not count
docs per term.
If you set 'numTerms=false' and 'facet.limit=0', it does nothing.
And, everything is called 'facet' and 'term' :)
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.patch, SOLR-2242.solr3.1.patch,
SOLR.2242.solr3.1.patch, SOLR.2242.v2.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=truefacet.field=manufacet.mincount=1facet.limit=-1f.manu.facet.namedistinct=0facet.field=pricef.price.facet.namedistinct=1
Here is an example on field hgid (without namedistinct):
{code}
- lst name=facet_fields
- lst name=hgid
int name=HGPY045FD36D4000A1/int
int name=HGPY0FBC6690453A91/int
int name=HGPY1E44ED6C4FB3B1/int
int name=HGPY1FA631034A1B81/int
int name=HGPY3317ABAC43B481/int
int name=HGPY3A17B2294CB5A5/int
int name=HGPY3ADD2B3D48C391/int
/lst
/lst
{code}
With namedistinct (HGPY045FD36D4000A, HGPY0FBC6690453A9,
HGPY1E44ED6C4FB3B, HGPY1FA631034A1B8, HGPY3317ABAC43B48,
HGPY3A17B2294CB5A, HGPY3ADD2B3D48C39). 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.
For more information on JIRA, see: http://www.atlassian.com/software/jira
-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Issue Comment Edited] (SOLR-2242) Get distinct count of names for a facet field
[
https://issues.apache.org/jira/browse/SOLR-2242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13008825#comment-13008825
]
Bill Bell edited comment on SOLR-2242 at 3/23/11 2:31 AM:
--
Can someone look this patch over?
Also requested +1 from Isha Garg isha.g...@orkash.com
Thanks,.
was (Author: billnbell):
Can someone loom this patch over?
Thanks,.
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.v2.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=truefacet.field=manufacet.mincount=1facet.limit=-1f.manu.facet.namedistinct=0facet.field=pricef.price.facet.namedistinct=1
Here is an example on field hgid (without namedistinct):
{code}
- lst name=facet_fields
- lst name=hgid
int name=HGPY045FD36D4000A1/int
int name=HGPY0FBC6690453A91/int
int name=HGPY1E44ED6C4FB3B1/int
int name=HGPY1FA631034A1B81/int
int name=HGPY3317ABAC43B481/int
int name=HGPY3A17B2294CB5A5/int
int name=HGPY3ADD2B3D48C391/int
/lst
/lst
{code}
With namedistinct (HGPY045FD36D4000A, HGPY0FBC6690453A9,
HGPY1E44ED6C4FB3B, HGPY1FA631034A1B8, HGPY3317ABAC43B48,
HGPY3A17B2294CB5A, HGPY3ADD2B3D48C39). 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.
For more information on JIRA, see: http://www.atlassian.com/software/jira
-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] Issue Comment Edited: (SOLR-2242) Get distinct count of names for a facet field
[
https://issues.apache.org/jira/browse/SOLR-2242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13006806#comment-13006806
]
Bill Bell edited comment on SOLR-2242 at 3/15/11 6:06 AM:
--
v2 of the release based on feedback.
Note: SOLR-2242-distinctFacet.patch not needed (left for history)
was (Author: billnbell):
v2 of the release based on feedback.
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, SOLR-2242.v2.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=truefacet.field=manufacet.mincount=1facet.limit=-1f.manu.facet.namedistinct=0facet.field=pricef.price.facet.namedistinct=1
Here is an example on field hgid (without namedistinct):
{code}
- lst name=facet_fields
- lst name=hgid
int name=HGPY045FD36D4000A1/int
int name=HGPY0FBC6690453A91/int
int name=HGPY1E44ED6C4FB3B1/int
int name=HGPY1FA631034A1B81/int
int name=HGPY3317ABAC43B481/int
int name=HGPY3A17B2294CB5A5/int
int name=HGPY3ADD2B3D48C391/int
/lst
/lst
{code}
With namedistinct (HGPY045FD36D4000A, HGPY0FBC6690453A9,
HGPY1E44ED6C4FB3B, HGPY1FA631034A1B8, HGPY3317ABAC43B48,
HGPY3A17B2294CB5A, HGPY3ADD2B3D48C39). 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.
For more information on JIRA, see: http://www.atlassian.com/software/jira
-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] Issue Comment Edited: (SOLR-2242) Get distinct count of names for a facet field
[
https://issues.apache.org/jira/browse/SOLR-2242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13006779#comment-13006779
]
Bill Bell edited comment on SOLR-2242 at 3/15/11 6:06 AM:
--
No actually namedistinct is not the number of values. It is the number of names.
{code}
- lst name=facet_fields
- lst name=hgid
int name=HGPY045FD36D4000A1/int
int name=HGPY0FBC6690453A91/int
int name=HGPY1E44ED6C4FB3B1/int
int name=HGPY1FA631034A1B81/int
int name=HGPY3317ABAC43B481/int
int name=HGPY3A17B2294CB5A5/int
int name=HGPY3ADD2B3D48C391/int
/lst
/lst
{code}
Becomes:
{code}
lst name=facet_fields
lst name=hgid
int name=namedistinct7/int !-- this is not 11 --
lst name=counts
int name=HGPY045FD36D4000A1/int
int name=HGPY0FBC6690453A91/int
int name=HGPY1E44ED6C4FB3B1/int
int name=HGPY1FA631034A1B81/int
int name=HGPY3317ABAC43B481/int
int name=HGPY3A17B2294CB5A5/int
int name=HGPY3ADD2B3D48C391/int
/lst
/lst
/lst
{code}
was (Author: billnbell):
No actually namedistinct is not the number of values. It is the number of
names.
{code}
- lst name=facet_fields
- lst name=hgid
int name=HGPY045FD36D4000A1/int
int name=HGPY0FBC6690453A91/int
int name=HGPY1E44ED6C4FB3B1/int
int name=HGPY1FA631034A1B81/int
int name=HGPY3317ABAC43B481/int
int name=HGPY3A17B2294CB5A5/int
int name=HGPY3ADD2B3D48C391/int
/lst
/lst
{code}
Becomes:
{code}
lst name=facet_fields
lst name=hgid
int name=namedistinct7/int !-- this is not 11 --
lst name=hgid
int name=HGPY045FD36D4000A1/int
int name=HGPY0FBC6690453A91/int
int name=HGPY1E44ED6C4FB3B1/int
int name=HGPY1FA631034A1B81/int
int name=HGPY3317ABAC43B481/int
int name=HGPY3A17B2294CB5A5/int
int name=HGPY3ADD2B3D48C391/int
/lst
/lst
/lst
{code}
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, SOLR-2242.v2.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=truefacet.field=manufacet.mincount=1facet.limit=-1f.manu.facet.namedistinct=0facet.field=pricef.price.facet.namedistinct=1
Here is an example on field hgid (without namedistinct):
{code}
- lst name=facet_fields
- lst name=hgid
int name=HGPY045FD36D4000A1/int
int name=HGPY0FBC6690453A91/int
int name=HGPY1E44ED6C4FB3B1/int
int name=HGPY1FA631034A1B81/int
int name=HGPY3317ABAC43B481/int
int name=HGPY3A17B2294CB5A5/int
int name=HGPY3ADD2B3D48C391/int
/lst
/lst
{code}
With namedistinct (HGPY045FD36D4000A, HGPY0FBC6690453A9,
HGPY1E44ED6C4FB3B, HGPY1FA631034A1B8, HGPY3317ABAC43B48,
HGPY3A17B2294CB5A, HGPY3ADD2B3D48C39). 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.
For more information on JIRA, see: http://www.atlassian.com/software/jira
-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] Issue Comment Edited: (SOLR-2242) Get distinct count of names for a facet field
[
https://issues.apache.org/jira/browse/SOLR-2242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13006805#comment-13006805
]
Bill Bell edited comment on SOLR-2242 at 3/15/11 6:10 AM:
--
OK this is complete.
Sample query:
http://localhost:8983/solr/select?q=*:*facet=truefacet.field=catrows=0facet.numfacetterms=2facet.limit=4
Sample output:
{code}
?xml version=1.0 encoding=UTF-8 ?
- response
- lst name=responseHeader
int name=status0/int
int name=QTime0/int
- lst name=params
str name=facet.numfacetterms2/str
str name=facettrue/str
str name=q*:*/str
str name=facet.limit4/str
str name=facet.fieldcat/str
str name=rows0/str
/lst
/lst
result name=response numFound=17 start=0 /
- lst name=facet_counts
lst name=facet_queries /
- lst name=facet_fields
- lst name=cat
int name=numFacetTerms14/int
- lst name=counts
int name=electronics14/int
int name=memory3/int
int name=connector2/int
int name=graphics card2/int
/lst
/lst
/lst
lst name=facet_dates /
lst name=facet_ranges /
/lst
/response
{code}
In Json:
{code}
facet_fields:{cat:[numFacetTerms,14,counts,[electronics,14,memory,3,connector,2,graphics
card,2]]},facet_dates:{},facet_ranges:{}}}
{code}
was (Author: billnbell):
OK this is complete.
Sample query:
http://localhost:8983/solr/select?q=*:*facet=truefacet.field=catrows=0facet.numfacetterms=2facet.limit=4
Sample output:
{code}
?xml version=1.0 encoding=UTF-8 ?
- response
- lst name=responseHeader
int name=status0/int
int name=QTime0/int
- lst name=params
str name=facet.numfacetterms2/str
str name=facettrue/str
str name=q*:*/str
str name=facet.limit4/str
str name=facet.fieldcat/str
str name=rows0/str
/lst
/lst
result name=response numFound=17 start=0 /
- lst name=facet_counts
lst name=facet_queries /
- lst name=facet_fields
- lst name=cat
int name=numFacetTerms14/int
- lst name=counts
int name=electronics14/int
int name=memory3/int
int name=connector2/int
int name=graphics card2/int
/lst
/lst
/lst
lst name=facet_dates /
lst name=facet_ranges /
/lst
/response
{code}
In Json:
{code}
{responseHeader:{status:0,QTime:0,params:{facet.numfacetterms:2,facet:true,q:*:*,facet.limit:4,facet.field:cat,wt:json,rows:0}},response:{numFound:17,start:0,docs:[]},facet_counts:{facet_queries:{},facet_fields:{cat:[numFacetTerms,14,counts,[electronics,14,memory,3,connector,2,graphics
card,2]]},facet_dates:{},facet_ranges:{}}}
{code}
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, SOLR-2242.v2.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=truefacet.field=manufacet.mincount=1facet.limit=-1f.manu.facet.namedistinct=0facet.field=pricef.price.facet.namedistinct=1
Here is an example on field hgid (without namedistinct):
{code}
- lst name=facet_fields
- lst name=hgid
int name=HGPY045FD36D4000A1/int
int name=HGPY0FBC6690453A91/int
int name=HGPY1E44ED6C4FB3B1/int
int name=HGPY1FA631034A1B81/int
int name=HGPY3317ABAC43B481/int
int name=HGPY3A17B2294CB5A5/int
int name=HGPY3ADD2B3D48C391/int
/lst
/lst
{code}
With namedistinct (HGPY045FD36D4000A, HGPY0FBC6690453A9,
HGPY1E44ED6C4FB3B, HGPY1FA631034A1B8, HGPY3317ABAC43B48,
HGPY3A17B2294CB5A, HGPY3ADD2B3D48C39). 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.
For more information on JIRA, see: http://www.atlassian.com/software/jira
-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] Issue Comment Edited: (SOLR-2242) Get distinct count of names for a facet field
[
https://issues.apache.org/jira/browse/SOLR-2242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13006805#comment-13006805
]
Bill Bell edited comment on SOLR-2242 at 3/15/11 6:16 AM:
--
OK this is complete.
Sample query:
http://localhost:8983/solr/select?q=*:*facet=truefacet.field=catrows=0facet.numfacetterms=2facet.limit=4
Sample output:
{code}
?xml version=1.0 encoding=UTF-8 ?
response
lst name=responseHeader
int name=status0/int
int name=QTime0/int
lst name=params
str name=facet.numfacetterms2/str
str name=facettrue/str
str name=q*:*/str
str name=facet.limit4/str
str name=facet.fieldcat/str
str name=rows0/str
/lst
/lst
result name=response numFound=17 start=0 /
lst name=facet_counts
lst name=facet_queries /
lst name=facet_fields
lst name=cat
int name=numFacetTerms14/int
lst name=counts
int name=electronics14/int
int name=memory3/int
int name=connector2/int
int name=graphics card2/int
/lst
/lst
/lst
lst name=facet_dates /
lst name=facet_ranges /
/lst
/response
{code}
In Json:
{code}
facet_fields:{cat:[numFacetTerms,14,counts,[electronics,14,memory,3,connector,2,graphics
card,2]]},facet_dates:{},facet_ranges:{}}}
{code}
was (Author: billnbell):
OK this is complete.
Sample query:
http://localhost:8983/solr/select?q=*:*facet=truefacet.field=catrows=0facet.numfacetterms=2facet.limit=4
Sample output:
{code}
?xml version=1.0 encoding=UTF-8 ?
- response
- lst name=responseHeader
int name=status0/int
int name=QTime0/int
- lst name=params
str name=facet.numfacetterms2/str
str name=facettrue/str
str name=q*:*/str
str name=facet.limit4/str
str name=facet.fieldcat/str
str name=rows0/str
/lst
/lst
result name=response numFound=17 start=0 /
- lst name=facet_counts
lst name=facet_queries /
- lst name=facet_fields
- lst name=cat
int name=numFacetTerms14/int
- lst name=counts
int name=electronics14/int
int name=memory3/int
int name=connector2/int
int name=graphics card2/int
/lst
/lst
/lst
lst name=facet_dates /
lst name=facet_ranges /
/lst
/response
{code}
In Json:
{code}
facet_fields:{cat:[numFacetTerms,14,counts,[electronics,14,memory,3,connector,2,graphics
card,2]]},facet_dates:{},facet_ranges:{}}}
{code}
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, SOLR-2242.v2.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=truefacet.field=manufacet.mincount=1facet.limit=-1f.manu.facet.namedistinct=0facet.field=pricef.price.facet.namedistinct=1
Here is an example on field hgid (without namedistinct):
{code}
- lst name=facet_fields
- lst name=hgid
int name=HGPY045FD36D4000A1/int
int name=HGPY0FBC6690453A91/int
int name=HGPY1E44ED6C4FB3B1/int
int name=HGPY1FA631034A1B81/int
int name=HGPY3317ABAC43B481/int
int name=HGPY3A17B2294CB5A5/int
int name=HGPY3ADD2B3D48C391/int
/lst
/lst
{code}
With namedistinct (HGPY045FD36D4000A, HGPY0FBC6690453A9,
HGPY1E44ED6C4FB3B, HGPY1FA631034A1B8, HGPY3317ABAC43B48,
HGPY3A17B2294CB5A, HGPY3ADD2B3D48C39). 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.
For more information on JIRA, see: http://www.atlassian.com/software/jira
-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] Issue Comment Edited: (SOLR-2242) Get distinct count of names for a facet field
[
https://issues.apache.org/jira/browse/SOLR-2242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13006805#comment-13006805
]
Bill Bell edited comment on SOLR-2242 at 3/15/11 6:20 AM:
--
OK this is complete.
Sample query:
http://localhost:8983/solr/select?q=*:*facet=truefacet.field=catrows=0facet.numFacetTerms=2facet.limit=4
Sample output:
{code}
?xml version=1.0 encoding=UTF-8 ?
response
lst name=responseHeader
int name=status0/int
int name=QTime0/int
lst name=params
str name=facet.numfacetterms2/str
str name=facettrue/str
str name=q*:*/str
str name=facet.limit4/str
str name=facet.fieldcat/str
str name=rows0/str
/lst
/lst
result name=response numFound=17 start=0 /
lst name=facet_counts
lst name=facet_queries /
lst name=facet_fields
lst name=cat
int name=numFacetTerms14/int
lst name=counts
int name=electronics14/int
int name=memory3/int
int name=connector2/int
int name=graphics card2/int
/lst
/lst
/lst
lst name=facet_dates /
lst name=facet_ranges /
/lst
/response
{code}
In Json:
{code}
facet_fields:{cat:[numFacetTerms,14,counts,[electronics,14,memory,3,connector,2,graphics
card,2]]},facet_dates:{},facet_ranges:{}}}
{code}
was (Author: billnbell):
OK this is complete.
Sample query:
http://localhost:8983/solr/select?q=*:*facet=truefacet.field=catrows=0facet.numfacetterms=2facet.limit=4
Sample output:
{code}
?xml version=1.0 encoding=UTF-8 ?
response
lst name=responseHeader
int name=status0/int
int name=QTime0/int
lst name=params
str name=facet.numfacetterms2/str
str name=facettrue/str
str name=q*:*/str
str name=facet.limit4/str
str name=facet.fieldcat/str
str name=rows0/str
/lst
/lst
result name=response numFound=17 start=0 /
lst name=facet_counts
lst name=facet_queries /
lst name=facet_fields
lst name=cat
int name=numFacetTerms14/int
lst name=counts
int name=electronics14/int
int name=memory3/int
int name=connector2/int
int name=graphics card2/int
/lst
/lst
/lst
lst name=facet_dates /
lst name=facet_ranges /
/lst
/response
{code}
In Json:
{code}
facet_fields:{cat:[numFacetTerms,14,counts,[electronics,14,memory,3,connector,2,graphics
card,2]]},facet_dates:{},facet_ranges:{}}}
{code}
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, SOLR-2242.v2.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=truefacet.field=manufacet.mincount=1facet.limit=-1f.manu.facet.namedistinct=0facet.field=pricef.price.facet.namedistinct=1
Here is an example on field hgid (without namedistinct):
{code}
- lst name=facet_fields
- lst name=hgid
int name=HGPY045FD36D4000A1/int
int name=HGPY0FBC6690453A91/int
int name=HGPY1E44ED6C4FB3B1/int
int name=HGPY1FA631034A1B81/int
int name=HGPY3317ABAC43B481/int
int name=HGPY3A17B2294CB5A5/int
int name=HGPY3ADD2B3D48C391/int
/lst
/lst
{code}
With namedistinct (HGPY045FD36D4000A, HGPY0FBC6690453A9,
HGPY1E44ED6C4FB3B, HGPY1FA631034A1B8, HGPY3317ABAC43B48,
HGPY3A17B2294CB5A, HGPY3ADD2B3D48C39). 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.
For more information on JIRA, see: http://www.atlassian.com/software/jira
-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] Issue Comment Edited: (SOLR-2242) Get distinct count of names for a facet field
[
https://issues.apache.org/jira/browse/SOLR-2242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13006792#comment-13006792
]
Bill Bell edited comment on SOLR-2242 at 3/15/11 8:22 AM:
--
I am going to use your suggestion. You will not have to set the limit. Getting
the numFacetTerms will be optional, and you also will be able to NOT get the
hgids as well. I propose this (please comment):
This will ONLY output the numFacetTerms (no hgid facet counts):
http://localhost:8983/solr/select?q=*:*facet=truefacet.field=hgidf.hgid.facet.numFacetTerms=1
This assumes the count will be limit=-1
{code}
lst name=facet_fields
lst name=hgid
int name=numFacetTerms7/int !-- this is not 11 --
/lst
/lst
{code}
This will output the numFacetTerms AND hgid:
http://localhost:8983/solr/select?q=*:*facet=truefacet.field=hgidfacet.mincount=1f.hgid.facet.numFacetTerms=2
{code}
lst name=facet_fields
lst name=hgid
int name=numFacetTerms7/int !-- this is not 11 --
lst name=counts
int name=HGPY045FD36D4000A1/int
int name=HGPY0FBC6690453A91/int
int name=HGPY1E44ED6C4FB3B1/int
int name=HGPY1FA631034A1B81/int
int name=HGPY3317ABAC43B481/int
int name=HGPY3A17B2294CB5A5/int
int name=HGPY3ADD2B3D48C391/int
/lst
/lst
/lst
{code}
was (Author: billnbell):
I am going to use your suggestion. You will not have to set the limit.
Getting the numFacetTerms will be optional, and you also will be able to NOT
get the hgids as well. I propose this (please comment):
This will ONLY output the numFacetTerms (no hgid facet counts):
http://localhost:8983/solr/select?q=*:*facet=truefacet.field=hgidf.hgid.facet.numfacetterms=1
This assumes the count will be limit=-1
{code}
lst name=facet_fields
lst name=hgid
int name=numFacetTerms7/int !-- this is not 11 --
/lst
/lst
{code}
This will output the numFacetTerms AND hgid:
http://localhost:8983/solr/select?q=*:*facet=truefacet.field=hgidfacet.mincount=1f.hgid.facet.numfacetterms=2
{code}
lst name=facet_fields
lst name=hgid
int name=numFacetTerms7/int !-- this is not 11 --
lst name=counts
int name=HGPY045FD36D4000A1/int
int name=HGPY0FBC6690453A91/int
int name=HGPY1E44ED6C4FB3B1/int
int name=HGPY1FA631034A1B81/int
int name=HGPY3317ABAC43B481/int
int name=HGPY3A17B2294CB5A5/int
int name=HGPY3ADD2B3D48C391/int
/lst
/lst
/lst
{code}
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.v2.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=truefacet.field=manufacet.mincount=1facet.limit=-1f.manu.facet.namedistinct=0facet.field=pricef.price.facet.namedistinct=1
Here is an example on field hgid (without namedistinct):
{code}
- lst name=facet_fields
- lst name=hgid
int name=HGPY045FD36D4000A1/int
int name=HGPY0FBC6690453A91/int
int name=HGPY1E44ED6C4FB3B1/int
int name=HGPY1FA631034A1B81/int
int name=HGPY3317ABAC43B481/int
int name=HGPY3A17B2294CB5A5/int
int name=HGPY3ADD2B3D48C391/int
/lst
/lst
{code}
With namedistinct (HGPY045FD36D4000A, HGPY0FBC6690453A9,
HGPY1E44ED6C4FB3B, HGPY1FA631034A1B8, HGPY3317ABAC43B48,
HGPY3A17B2294CB5A, HGPY3ADD2B3D48C39). 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.
For more information on JIRA, see: http://www.atlassian.com/software/jira
-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] Issue Comment Edited: (SOLR-2242) Get distinct count of names for a facet field
[
https://issues.apache.org/jira/browse/SOLR-2242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13006792#comment-13006792
]
Bill Bell edited comment on SOLR-2242 at 3/15/11 5:04 AM:
--
I am going to use your suggestion. You will not have to set the limit or
mincount. Getting the numFacetTerms will be optional, and you also will be able
to NOT get the hgids as well. I propose this (please comment):
This will ONLY output the numFacetTerms (no hgid facet counts):
http://localhost:8983/solr/select?q=*:*facet=truefacet.field=hgidf.hgid.facet.numfacetterms=1
This assumes the count will be mincount=1, and limit=-1
{code}
lst name=facet_fields
lst name=hgid
int name=numFacetTerms7/int !-- this is not 11 --
/lst
/lst
{code}
This will output the numFacetTerms AND hgid:
http://localhost:8983/solr/select?q=*:*facet=truefacet.field=hgidfacet.mincount=1f.hgid.facet.numfacetterms=2
{code}
lst name=facet_fields
lst name=hgid
int name=numFacetTerms7/int !-- this is not 11 --
lst name=hgid
int name=HGPY045FD36D4000A1/int
int name=HGPY0FBC6690453A91/int
int name=HGPY1E44ED6C4FB3B1/int
int name=HGPY1FA631034A1B81/int
int name=HGPY3317ABAC43B481/int
int name=HGPY3A17B2294CB5A5/int
int name=HGPY3ADD2B3D48C391/int
/lst
/lst
/lst
{code}
was (Author: billnbell):
I am going to use your suggestion. You will not have to set the limit or
mincount. Getting the numFacetTerms will be optional, and you also will be able
to NOT get the hgids as well. I propose this (please comment):
This will ONLY output the numFacetTerms (no hgid facet counts):
http://localhost:8983/solr/select?q=*:*facet=truefacet.field=hgidf.hgid.facet.numfacetterms=true
This assumes the count will be mincount=1, and limit=-1
{code}
lst name=facet_fields
lst name=hgid
int name=numFacetTerms7/int !-- this is not 11 --
/lst
/lst
{code}
This will output the numFacetTerms AND hgid:
http://localhost:8983/solr/select?q=*:*facet=truefacet.field=hgidfacet.mincount=1f.hgid.facet.numfacetterms=both
{code}
lst name=facet_fields
lst name=hgid
int name=numFacetTerms7/int !-- this is not 11 --
lst name=hgid
int name=HGPY045FD36D4000A1/int
int name=HGPY0FBC6690453A91/int
int name=HGPY1E44ED6C4FB3B1/int
int name=HGPY1FA631034A1B81/int
int name=HGPY3317ABAC43B481/int
int name=HGPY3A17B2294CB5A5/int
int name=HGPY3ADD2B3D48C391/int
/lst
/lst
/lst
{code}
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=truefacet.field=manufacet.mincount=1facet.limit=-1f.manu.facet.namedistinct=0facet.field=pricef.price.facet.namedistinct=1
Here is an example on field hgid (without namedistinct):
{code}
- lst name=facet_fields
- lst name=hgid
int name=HGPY045FD36D4000A1/int
int name=HGPY0FBC6690453A91/int
int name=HGPY1E44ED6C4FB3B1/int
int name=HGPY1FA631034A1B81/int
int name=HGPY3317ABAC43B481/int
int name=HGPY3A17B2294CB5A5/int
int name=HGPY3ADD2B3D48C391/int
/lst
/lst
{code}
With namedistinct (HGPY045FD36D4000A, HGPY0FBC6690453A9,
HGPY1E44ED6C4FB3B, HGPY1FA631034A1B8, HGPY3317ABAC43B48,
HGPY3A17B2294CB5A, HGPY3ADD2B3D48C39). 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.
For more information on JIRA, see: http://www.atlassian.com/software/jira
-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] Issue Comment Edited: (SOLR-2242) Get distinct count of names for a facet field
[
https://issues.apache.org/jira/browse/SOLR-2242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13006792#comment-13006792
]
Bill Bell edited comment on SOLR-2242 at 3/15/11 5:41 AM:
--
I am going to use your suggestion. You will not have to set the limit or
mincount. Getting the numFacetTerms will be optional, and you also will be able
to NOT get the hgids as well. I propose this (please comment):
This will ONLY output the numFacetTerms (no hgid facet counts):
http://localhost:8983/solr/select?q=*:*facet=truefacet.field=hgidf.hgid.facet.numfacetterms=1
This assumes the count will be mincount=1, and limit=-1
{code}
lst name=facet_fields
lst name=hgid
int name=numFacetTerms7/int !-- this is not 11 --
/lst
/lst
{code}
This will output the numFacetTerms AND hgid:
http://localhost:8983/solr/select?q=*:*facet=truefacet.field=hgidfacet.mincount=1f.hgid.facet.numfacetterms=2
{code}
lst name=facet_fields
lst name=hgid
int name=numFacetTerms7/int !-- this is not 11 --
lst name=counts
int name=HGPY045FD36D4000A1/int
int name=HGPY0FBC6690453A91/int
int name=HGPY1E44ED6C4FB3B1/int
int name=HGPY1FA631034A1B81/int
int name=HGPY3317ABAC43B481/int
int name=HGPY3A17B2294CB5A5/int
int name=HGPY3ADD2B3D48C391/int
/lst
/lst
/lst
{code}
was (Author: billnbell):
I am going to use your suggestion. You will not have to set the limit or
mincount. Getting the numFacetTerms will be optional, and you also will be able
to NOT get the hgids as well. I propose this (please comment):
This will ONLY output the numFacetTerms (no hgid facet counts):
http://localhost:8983/solr/select?q=*:*facet=truefacet.field=hgidf.hgid.facet.numfacetterms=1
This assumes the count will be mincount=1, and limit=-1
{code}
lst name=facet_fields
lst name=hgid
int name=numFacetTerms7/int !-- this is not 11 --
/lst
/lst
{code}
This will output the numFacetTerms AND hgid:
http://localhost:8983/solr/select?q=*:*facet=truefacet.field=hgidfacet.mincount=1f.hgid.facet.numfacetterms=2
{code}
lst name=facet_fields
lst name=hgid
int name=numFacetTerms7/int !-- this is not 11 --
lst name=hgid
int name=HGPY045FD36D4000A1/int
int name=HGPY0FBC6690453A91/int
int name=HGPY1E44ED6C4FB3B1/int
int name=HGPY1FA631034A1B81/int
int name=HGPY3317ABAC43B481/int
int name=HGPY3A17B2294CB5A5/int
int name=HGPY3ADD2B3D48C391/int
/lst
/lst
/lst
{code}
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=truefacet.field=manufacet.mincount=1facet.limit=-1f.manu.facet.namedistinct=0facet.field=pricef.price.facet.namedistinct=1
Here is an example on field hgid (without namedistinct):
{code}
- lst name=facet_fields
- lst name=hgid
int name=HGPY045FD36D4000A1/int
int name=HGPY0FBC6690453A91/int
int name=HGPY1E44ED6C4FB3B1/int
int name=HGPY1FA631034A1B81/int
int name=HGPY3317ABAC43B481/int
int name=HGPY3A17B2294CB5A5/int
int name=HGPY3ADD2B3D48C391/int
/lst
/lst
{code}
With namedistinct (HGPY045FD36D4000A, HGPY0FBC6690453A9,
HGPY1E44ED6C4FB3B, HGPY1FA631034A1B8, HGPY3317ABAC43B48,
HGPY3A17B2294CB5A, HGPY3ADD2B3D48C39). 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.
For more information on JIRA, see: http://www.atlassian.com/software/jira
-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] Issue Comment Edited: (SOLR-2242) Get distinct count of names for a facet field
[
https://issues.apache.org/jira/browse/SOLR-2242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13006792#comment-13006792
]
Bill Bell edited comment on SOLR-2242 at 3/15/11 5:45 AM:
--
I am going to use your suggestion. You will not have to set the limit. Getting
the numFacetTerms will be optional, and you also will be able to NOT get the
hgids as well. I propose this (please comment):
This will ONLY output the numFacetTerms (no hgid facet counts):
http://localhost:8983/solr/select?q=*:*facet=truefacet.field=hgidf.hgid.facet.numfacetterms=1
This assumes the count will be limit=-1
{code}
lst name=facet_fields
lst name=hgid
int name=numFacetTerms7/int !-- this is not 11 --
/lst
/lst
{code}
This will output the numFacetTerms AND hgid:
http://localhost:8983/solr/select?q=*:*facet=truefacet.field=hgidfacet.mincount=1f.hgid.facet.numfacetterms=2
{code}
lst name=facet_fields
lst name=hgid
int name=numFacetTerms7/int !-- this is not 11 --
lst name=counts
int name=HGPY045FD36D4000A1/int
int name=HGPY0FBC6690453A91/int
int name=HGPY1E44ED6C4FB3B1/int
int name=HGPY1FA631034A1B81/int
int name=HGPY3317ABAC43B481/int
int name=HGPY3A17B2294CB5A5/int
int name=HGPY3ADD2B3D48C391/int
/lst
/lst
/lst
{code}
was (Author: billnbell):
I am going to use your suggestion. You will not have to set the limit or
mincount. Getting the numFacetTerms will be optional, and you also will be able
to NOT get the hgids as well. I propose this (please comment):
This will ONLY output the numFacetTerms (no hgid facet counts):
http://localhost:8983/solr/select?q=*:*facet=truefacet.field=hgidf.hgid.facet.numfacetterms=1
This assumes the count will be mincount=1, and limit=-1
{code}
lst name=facet_fields
lst name=hgid
int name=numFacetTerms7/int !-- this is not 11 --
/lst
/lst
{code}
This will output the numFacetTerms AND hgid:
http://localhost:8983/solr/select?q=*:*facet=truefacet.field=hgidfacet.mincount=1f.hgid.facet.numfacetterms=2
{code}
lst name=facet_fields
lst name=hgid
int name=numFacetTerms7/int !-- this is not 11 --
lst name=counts
int name=HGPY045FD36D4000A1/int
int name=HGPY0FBC6690453A91/int
int name=HGPY1E44ED6C4FB3B1/int
int name=HGPY1FA631034A1B81/int
int name=HGPY3317ABAC43B481/int
int name=HGPY3A17B2294CB5A5/int
int name=HGPY3ADD2B3D48C391/int
/lst
/lst
/lst
{code}
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=truefacet.field=manufacet.mincount=1facet.limit=-1f.manu.facet.namedistinct=0facet.field=pricef.price.facet.namedistinct=1
Here is an example on field hgid (without namedistinct):
{code}
- lst name=facet_fields
- lst name=hgid
int name=HGPY045FD36D4000A1/int
int name=HGPY0FBC6690453A91/int
int name=HGPY1E44ED6C4FB3B1/int
int name=HGPY1FA631034A1B81/int
int name=HGPY3317ABAC43B481/int
int name=HGPY3A17B2294CB5A5/int
int name=HGPY3ADD2B3D48C391/int
/lst
/lst
{code}
With namedistinct (HGPY045FD36D4000A, HGPY0FBC6690453A9,
HGPY1E44ED6C4FB3B, HGPY1FA631034A1B8, HGPY3317ABAC43B48,
HGPY3A17B2294CB5A, HGPY3ADD2B3D48C39). 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.
For more information on JIRA, see: http://www.atlassian.com/software/jira
-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
