How can I use elastic4s to get all distinct values for particular field?
Example in JSON:
GET persons/_search
{
"size":"0",
"aggs" : {
"uniq_gender" : {
"terms" : { "field" : "Gender" }
}
}
}
Asked
Active
Viewed 227 times
2
smaiakov
- 470
- 5
- 20
2 Answers
0
Use terms aggregation.
It looks like this:
index: 'test',
body: {
"aggs": {
"uniq_gender": {
"terms": {"field": "Gender"}
}
}
},
The response would look a little something like:
{
"uniq_gender": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "male",
"doc_count": 55
},
{
"key": "female",
"doc_count": 38
},
{
"key": "other",
"doc_count": 1
}
]
}
}
Important to note from the docs:
terms aggregation should be a field of type keyword or any other data type suitable for bucket aggregations. In order to use it with text you will need to enable fielddata.
Meaning if your gender field is index'd as text you have to set fielddata to true on the mapping, find out how to do so here.
Tom Slabbaert
- 21,288
- 10
- 30
- 43
-
thank you. But the questions was - how can I do similar query by using elastic4s library – smaiakov May 23 '19 at 16:00
-
@smaiakov This [post](https://sksamuel.github.io/elastic4s/docs/search/search.html) might be useful to understand how to use terms aggregation in elastic4s DSL. – Nikolay Vasiliev May 25 '19 at 19:25
-
How to create tempalte using elastic4s from raw json haveing setting and mapping details. – user1668782 Aug 31 '19 at 13:12
0
For elastic4s client, use termsAgg(name: String, field: String).
For your case, code looks like this:
search("persons")
.size(0)
.aggs(
termsAgg("uniq_gender", "Gender")
)
Grandys
- 163
- 1
- 1
- 8