Skip to content

Instantly share code, notes, and snippets.

@mattweber
Created March 1, 2012 04:09
Show Gist options
  • Save mattweber/1947215 to your computer and use it in GitHub Desktop.
Save mattweber/1947215 to your computer and use it in GitHub Desktop.
ElasticSearch Multi-Select Faceting Example
This is an example how to perform multi-select faceting in ElasticSearch.
Selecting multiple values from the same facet will result in an OR filter between each of the values:
(facet1.value1 OR facet1.value2)
Faceting on more than one facet will result in an AND filter between each facet:
(facet1.value1 OR facet1.value2) AND (facet2.value1)
I have chosen to update the counts for each facet the selected value DOES NOT belong to since we are performing an AND between each facet. I have included an example that shows how to keep the counts if you don't want to do this (filter0.sh).
docs.sh - the example documents
query.sh - the initial query
filter0.sh - filter on tag "tag2", keeping counts
filter1.sh - filter on tag "tag2", update counts
filter2.sh - filter on tags "tag2" and "tag4", update counts
filter3.sh - filter on tags "tag2" and "tag4", keyword "keyword0", update counts
filter4.sh - filter on tags "tag2" and "tag4", keywords "keyword0" and "keyword2", update counts
curl -XPUT 'http://localhost:9200/multiselect/demo/1' -d '{
"title": "One",
"tags": ["tag1"],
"keywords": ["keyword1","keyword2","keyword3"]
}'
curl -XPUT 'http://localhost:9200/multiselect/demo/2' -d '{
"title": "Two",
"tags": ["tag1","tag2"],
"keywords": ["keyword1","keyword2"]
}'
curl -XPUT 'http://localhost:9200/multiselect/demo/3' -d '{
"title": "Three",
"tags": ["tag1","tag2","tag3"],
"keywords": ["keyword1"]
}'
curl -XPUT 'http://localhost:9200/multiselect/demo/4' -d '{
"title": "Four",
"tags": ["tag4"],
"keywords": ["keyword0"]
}'
curl -XGET 'http://localhost:9200/multiselect/demo/_search?pretty=true' -d '{
"query": {
"match_all": {}
},
"filter": {
"terms": {
"tags": ["tag2"]
}
},
"facets": {
"tagFacet": {
"terms": {
"field": "tags",
"all_terms": true
}
},
"keywordFacet": {
"terms": {
"field": "keywords",
"all_terms": true
}
}
}
}'
curl -XGET 'http://localhost:9200/multiselect/demo/_search?pretty=true' -d '{
"query": {
"match_all": {}
},
"filter": {
"terms": {
"tags": ["tag2"]
}
},
"facets": {
"tagFacet": {
"terms": {
"field": "tags",
"all_terms": true
}
},
"keywordFacet": {
"terms": {
"field": "keywords",
"all_terms": true
},
"facet_filter":{
"terms": {
"tags": ["tag2"]
}
}
}
}
}'
curl -XGET 'http://localhost:9200/multiselect/demo/_search?pretty=true' -d '{
"query": {
"match_all": {}
},
"filter": {
"terms": {
"tags": ["tag2","tag4"]
}
},
"facets": {
"tagFacet": {
"terms": {
"field": "tags",
"all_terms": true
}
},
"keywordFacet": {
"terms": {
"field": "keywords",
"all_terms": true
},
"facet_filter":{
"terms": {
"tags": ["tag2","tag4"]
}
}
}
}
}'
curl -XGET 'http://localhost:9200/multiselect/demo/_search?pretty=true' -d '{
"query": {
"match_all": {}
},
"filter": {
"and": [
{
"terms": {
"tags": ["tag2","tag4"]
}
},
{
"terms": {
"keywords": ["keyword0"]
}
}
]
},
"facets": {
"tagFacet": {
"terms": {
"field": "tags",
"all_terms": true
},
"facet_filter": {
"terms": {
"keywords": ["keyword0"]
}
}
},
"keywordFacet": {
"terms": {
"field": "keywords",
"all_terms": true
},
"facet_filter":{
"terms": {
"tags": ["tag2","tag4"]
}
}
}
}
}'
curl -XGET 'http://localhost:9200/multiselect/demo/_search?pretty=true' -d '{
"query": {
"match_all": {}
},
"filter": {
"and": [
{
"terms": {
"tags": ["tag2","tag4"]
}
},
{
"terms": {
"keywords": ["keyword0","keyword2"]
}
}
]
},
"facets": {
"tagFacet": {
"terms": {
"field": "tags",
"all_terms": true
},
"facet_filter": {
"terms": {
"keywords": ["keyword0","keyword2"]
}
}
},
"keywordFacet": {
"terms": {
"field": "keywords",
"all_terms": true
},
"facet_filter":{
"terms": {
"tags": ["tag2","tag4"]
}
}
}
}
}'
curl -XGET 'http://localhost:9200/multiselect/demo/_search?pretty=true' -d '{
"query": {
"match_all": {}
},
"facets": {
"tagFacet": {
"terms": {
"field": "tags",
"all_terms": true
}
},
"keywordFacet": {
"terms": {
"field": "keywords",
"all_terms": true
}
}
}
}'
@Meekohi
Copy link

Meekohi commented Jan 7, 2016

Anyone know how to do this with the new elasticsearch aggregations instead of facets?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment