Aggegation framework - Is there facet_filter analogue available?

Kaspars_Sprogis · December 14, 2013, 7:44pm

I just tried out new aggregation framework and wanted to see if new
aggregation could resolve my previously discussed and unresolved problem:
https://groups.google.com/forum/?fromgroups#!topic/elasticsearch/-oiL2hvjieY

Since aggregation framework is planned as replacement for facets, i am
wondering how can i filter term aggregations, without loosing actual terms,
because as soon as i add "filter", then aggregations return only count.
So i am looking something like "facet_filter" for facets.
Or this is feature is not yet developed?

Here is the mapping and sample data:

gist.github.com

https://gist.github.com/darklow/7957463

es_nested_facets_filter.sh

#!/bin/bash
# ========================================
# Nested facets filtering by parent in ElasticSearch
# --------------------------------------------------
# I need to get facets of departments for specific person for one movie genre:
# facets for credit.department where genre=comedy, credits.person_id=1
# I am using include_in_parent:true mapping to be able to facet_filter by parent genre
# ========================================

curl -X DELETE localhost:9200/movies

This file has been truncated. show original

Here is query i tried:
{
"query": {
"match": {
"credits.person_id": 1
}
},
"aggs": {
"departments": {
"terms": {
"field": "credits.department"
}
}
},
"size": 0
}

Results:
"aggregations": {
"departments": {
"buckets": [
{
"key": "producer",
"doc_count": 2
},
{
"key": "director",
"doc_count": 2
},
{
"key": "actor",
"doc_count": 2
}
]
}
}

When i tried adding filter i got following result, without ability to see
term value:

Query:
{
"query": {
"match": {
"credits.person_id": 1
}
},
"aggs": {
"departments": {
"terms": {
"field": "credits.department"
},
"filter": {
"term": {
"genre": "comedy"
}
}
}
},
"size": 0
}

Result:
"aggregations": {
"departments": {
"doc_count": 1
}
}

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/f9c0b90f-8d79-4e3f-bbbf-58df4c083294%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

jpountz · December 16, 2013, 12:17pm

Hi,

The issue is that you are trying to define two aggregations (a terms and a
filter) under the same name, and the aggregations framework only takes into
account one of them. I tried to fix your last query in the following
example: aggs_filter.json · GitHub

On Sat, Dec 14, 2013 at 8:44 PM, Kaspars Sprogis darklow@gmail.com wrote:

I just tried out new aggregation framework and wanted to see if new
aggregation could resolve my previously discussed and unresolved problem:

Redirecting to Google Groups

Since aggregation framework is planned as replacement for facets, i am
wondering how can i filter term aggregations, without loosing actual terms,
because as soon as i add "filter", then aggregations return only count.
So i am looking something like "facet_filter" for facets.
Or this is feature is not yet developed?

Here is the mapping and sample data:
Nested facets filtering by parent in ElasticSearch · GitHub

Here is query i tried:
{
"query": {
"match": {
"credits.person_id": 1
}
},
"aggs": {
"departments": {
"terms": {
"field": "credits.department"
}
}
},
"size": 0
}

Results:
"aggregations": {
"departments": {
"buckets": [
{
"key": "producer",
"doc_count": 2
},
{
"key": "director",
"doc_count": 2
},
{
"key": "actor",
"doc_count": 2
}
]
}
}

When i tried adding filter i got following result, without ability to see
term value:

Query:
{
"query": {
"match": {
"credits.person_id": 1
}
},
"aggs": {
"departments": {
"terms": {
"field": "credits.department"
},
"filter": {
"term": {
"genre": "comedy"
}
}
}
},
"size": 0
}

Result:
"aggregations": {
"departments": {
"doc_count": 1
}
}

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/f9c0b90f-8d79-4e3f-bbbf-58df4c083294%40googlegroups.com
.
For more options, visit https://groups.google.com/groups/opt_out.

--
Adrien Grand

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAL6Z4j7OyVj2Ot6Crp9Eu%3DtGwht87XDtJ5oNhnkm6LRF4-dSLw%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.

Kaspars_Sprogis · December 16, 2013, 1:50pm

Sorry, my bad, used wrong hierarchy/syntax.
Thank you for sharing, there are very few advanced examples on new
aggregation framework right now, so this is very helpful.

On Monday, December 16, 2013 2:17:26 PM UTC+2, Adrien Grand wrote:

Hi,

The issue is that you are trying to define two aggregations (a terms and a
filter) under the same name, and the aggregations framework only takes into
account one of them. I tried to fix your last query in the following
example: aggs_filter.json · GitHub

On Sat, Dec 14, 2013 at 8:44 PM, Kaspars Sprogis <dar...@gmail.com<javascript:>

wrote:

I just tried out new aggregation framework and wanted to see if new
aggregation could resolve my previously discussed and unresolved problem:

Redirecting to Google Groups

Since aggregation framework is planned as replacement for facets, i am
wondering how can i filter term aggregations, without loosing actual terms,
because as soon as i add "filter", then aggregations return only count.
So i am looking something like "facet_filter" for facets.
Or this is feature is not yet developed?

Here is the mapping and sample data:
Nested facets filtering by parent in ElasticSearch · GitHub

Here is query i tried:
{
"query": {
"match": {
"credits.person_id": 1
}
},
"aggs": {
"departments": {
"terms": {
"field": "credits.department"
}
}
},
"size": 0
}

Results:
"aggregations": {
"departments": {
"buckets": [
{
"key": "producer",
"doc_count": 2
},
{
"key": "director",
"doc_count": 2
},
{
"key": "actor",
"doc_count": 2
}
]
}
}

When i tried adding filter i got following result, without ability to see
term value:

Query:
{
"query": {
"match": {
"credits.person_id": 1
}
},
"aggs": {
"departments": {
"terms": {
"field": "credits.department"
},
"filter": {
"term": {
"genre": "comedy"
}
}
}
},
"size": 0
}

Result:
"aggregations": {
"departments": {
"doc_count": 1
}
}

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearc...@googlegroups.com <javascript:>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/f9c0b90f-8d79-4e3f-bbbf-58df4c083294%40googlegroups.com
.
For more options, visit https://groups.google.com/groups/opt_out.

--
Adrien Grand

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/d3b8938d-1859-442c-a947-9baf2b405548%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.