Inconsistent facet count

stratospark · May 23, 2011, 10:53pm

Hi,

I'm trying to get a drill down searching interface going, with updated
facet counts as you drill down. I'm currently mapping all my strings
as multi_field, with the non-analyzed string value going into
"attribute.orig" and the analyzed one going into plain "attribute"

Here are two sets of requests/responses. The first one I want to get
the top location_name count facet, which returns 17. When I narrow
down the query to only search for location_name.orig "49296", the
facet count increases to 24.

I've tried applying a location_name.orig filter to the match_all
query, but that results in the same thing.

Am I doing something wrong?

Thanks for the help!
-pat

curl -XPOST http://127.0.0.1:9200/_search -d '
{
"query": {
"match_all": {}
},
"facets": {
"location.location_name": {
"terms": {
"field": "location.location_name.orig",
"size": 1
}
}
},
"size": 0
}'

{
"took":12,
"timed_out":false,
"_shards":{
"total":20,
"successful":20,
"failed":0
},
"hits":{
"total":41526,
"max_score":1.0,
"hits":[

},
"facets":{
"location.location_name":{
"_type":"terms",
"missing":8,
"terms":[
{
"term":"49296",
"count":17
}
]
}
}
}

curl -XPOST http://127.0.0.1:9200/_search -d '
{
"query": {
"term": {
"location.location_name.orig": "49296"
}
},
"facets": {
"location.location_name": {
"terms": {
"field": "location.location_name.orig",
"size": 1
}
}
},
"size": 0
}'

{
"took":12,
"timed_out":false,
"_shards":{
"total":20,
"successful":20,
"failed":0
},
"hits":{
"total":24,
"max_score":8.651358,
"hits":[

},
"facets":{
"location.location_name":{
"_type":"terms",
"missing":0,
"terms":[
{
"term":"49296",
"count":24
}
]
}
}
}

kimchy · May 23, 2011, 10:55pm

Can you gist a recreation where you also index sample docs?
On Tuesday, May 24, 2011 at 1:53 AM, stratospark wrote:

Hi,

I'm trying to get a drill down searching interface going, with updated
facet counts as you drill down. I'm currently mapping all my strings
as multi_field, with the non-analyzed string value going into
"attribute.orig" and the analyzed one going into plain "attribute"

Here are two sets of requests/responses. The first one I want to get
the top location_name count facet, which returns 17. When I narrow
down the query to only search for location_name.orig "49296", the
facet count increases to 24.

I've tried applying a location_name.orig filter to the match_all
query, but that results in the same thing.

Am I doing something wrong?

Thanks for the help!
-pat

curl -XPOST http://127.0.0.1:9200/_search -d '
{
"query": {
"match_all": {}
},
"facets": {
"location.location_name": {
"terms": {
"field": "location.location_name.orig",
"size": 1
}
}
},
"size": 0
}'

{
"took":12,
"timed_out":false,
"_shards":{
"total":20,
"successful":20,
"failed":0
},
"hits":{
"total":41526,
"max_score":1.0,
"hits":[

]
},
"facets":{
"location.location_name":{
"_type":"terms",
"missing":8,
"terms":[
{
"term":"49296",
"count":17
}
]
}
}
}

curl -XPOST http://127.0.0.1:9200/_search -d '
{
"query": {
"term": {
"location.location_name.orig": "49296"
}
},
"facets": {
"location.location_name": {
"terms": {
"field": "location.location_name.orig",
"size": 1
}
}
},
"size": 0
}'

{
"took":12,
"timed_out":false,
"_shards":{
"total":20,
"successful":20,
"failed":0
},
"hits":{
"total":24,
"max_score":8.651358,
"hits":[

]
},
"facets":{
"location.location_name":{
"_type":"terms",
"missing":0,
"terms":[
{
"term":"49296",
"count":24
}
]
}
}
}

stratospark · May 24, 2011, 1:52am

Create a simplified sample and the results are even stranger.

I also noticed it wasn't picking up my "include_in_all" option in the
dynamic template, which I think I need to generate facets on
multifields?

gist.github.com

https://gist.github.com/stratospark/987814

gistfile1.txt

Using elasticsearch/0.16.0
on
Java(TM) SE Runtime Environment (build 1.6.0_24-b07-334-10M3326)

Added this dynamic template

curl -XGET http://127.0.0.1:9200/samples/sample/_mapping?pretty=true
{
  "sample" : {
    "dynamic_templates" : [ {

This file has been truncated. show original

Thanks so much for the help!

-pat

On May 23, 3:55 pm, Shay Banon shay.ba...@elasticsearch.com wrote:

Can you gist a recreation where you also index sample docs?

On Tuesday, May 24, 2011 at 1:53 AM, stratospark wrote:

Hi,

I'm trying to get a drill down searching interface going, with updated
facet counts as you drill down. I'm currently mapping all my strings
as multi_field, with the non-analyzed string value going into
"attribute.orig" and the analyzed one going into plain "attribute"

Here are two sets of requests/responses. The first one I want to get
the top location_name count facet, which returns 17. When I narrow
down the query to only search for location_name.orig "49296", the
facet count increases to 24.

I've tried applying a location_name.orig filter to the match_all
query, but that results in the same thing.

Am I doing something wrong?

Thanks for the help!
-pat

curl -XPOSThttp://127.0.0.1:9200/_search-d '
{
"query": {
"match_all": {}
},
"facets": {
"location.location_name": {
"terms": {
"field": "location.location_name.orig",
"size": 1
}
}
},
"size": 0
}'

{
"took":12,
"timed_out":false,
"_shards":{
"total":20,
"successful":20,
"failed":0
},
"hits":{
"total":41526,
"max_score":1.0,
"hits":[

]
},
"facets":{
"location.location_name":{
"_type":"terms",
"missing":8,
"terms":[
{
"term":"49296",
"count":17
}
]
}
}
}

curl -XPOSThttp://127.0.0.1:9200/_search-d '
{
"query": {
"term": {
"location.location_name.orig": "49296"
}
},
"facets": {
"location.location_name": {
"terms": {
"field": "location.location_name.orig",
"size": 1
}
}
},
"size": 0
}'

{
"took":12,
"timed_out":false,
"_shards":{
"total":20,
"successful":20,
"failed":0
},
"hits":{
"total":24,
"max_score":8.651358,
"hits":[

]
},
"facets":{
"location.location_name":{
"_type":"terms",
"missing":0,
"terms":[
{
"term":"49296",
"count":24
}
]
}
}
}

kimchy · May 24, 2011, 2:34pm

This happens because of the way the distributed facet calculation works. It gets the top 5 from each shard, and then aggregates it. Because you have an even distribution of terms, it will not return exact matches. if you increase the size, you will get better results. One possible value can be the size times the number of shards, for example: 25.
On Tuesday, May 24, 2011 at 4:52 AM, stratospark wrote:

Create a simplified sample and the results are even stranger.

I also noticed it wasn't picking up my "include_in_all" option in the
dynamic template, which I think I need to generate facets on
multifields?

facet counts · GitHub

Thanks so much for the help!

-pat

On May 23, 3:55 pm, Shay Banon shay.ba...@elasticsearch.com wrote:

Can you gist a recreation where you also index sample docs?

On Tuesday, May 24, 2011 at 1:53 AM, stratospark wrote:

Hi,

I'm trying to get a drill down searching interface going, with updated
facet counts as you drill down. I'm currently mapping all my strings
as multi_field, with the non-analyzed string value going into
"attribute.orig" and the analyzed one going into plain "attribute"

Here are two sets of requests/responses. The first one I want to get
the top location_name count facet, which returns 17. When I narrow
down the query to only search for location_name.orig "49296", the
facet count increases to 24.

I've tried applying a location_name.orig filter to the match_all
query, but that results in the same thing.

Am I doing something wrong?

Thanks for the help!
-pat

curl -XPOSThttp://127.0.0.1:9200/_search-d '
{
"query": {
"match_all": {}
},
"facets": {
"location.location_name": {
"terms": {
"field": "location.location_name.orig",
"size": 1
}
}
},
"size": 0
}'

{
"took":12,
"timed_out":false,
"_shards":{
"total":20,
"successful":20,
"failed":0
},
"hits":{
"total":41526,
"max_score":1.0,
"hits":[

]
},
"facets":{
"location.location_name":{
"_type":"terms",
"missing":8,
"terms":[
{
"term":"49296",
"count":17
}
]
}
}
}

curl -XPOSThttp://127.0.0.1:9200/_search-d '
{
"query": {
"term": {
"location.location_name.orig": "49296"
}
},
"facets": {
"location.location_name": {
"terms": {
"field": "location.location_name.orig",
"size": 1
}
}
},
"size": 0
}'

{
"took":12,
"timed_out":false,
"_shards":{
"total":20,
"successful":20,
"failed":0
},
"hits":{
"total":24,
"max_score":8.651358,
"hits":[

]
},
"facets":{
"location.location_name":{
"_type":"terms",
"missing":0,
"terms":[
{
"term":"49296",
"count":24
}
]
}
}
}

Topic		Replies	Views
Double Counting in Multi Field Facet Search Elasticsearch	1	336	July 6, 2017
Facet count seems to be wrong ?! Elasticsearch	1	274	July 6, 2017
Terms facet with multi-fields and count Elasticsearch	3	324	July 6, 2017
Facet counting on non unique tag collection Elasticsearch	7	451	July 6, 2017
Facets & string query vs. match_all Elasticsearch	2	332	July 6, 2017

Inconsistent facet count

Related topics