Term aggregation not returning all unique values

Elastic Stack Elasticsearch
1

Hi ,

I am using Term Aggregations to get unique values for fields to show them as filters. however I am not getting all the results from ES.
code .
GET /_search { "aggs" : { "genres" : { "terms" : { "field" : "TEST_CountryArray.keyword" } } } }
output..
China Andorra Germany Algeria Brazil Afghanistan Angola Australia Austria Cyprus

but I know that I have job with UK(in capital lettlers, not sure if thats an issue) in countries list which is inserted to ES later point of time.
query:
`GET jobs/_search
{

"query":{"bool":{"must":[{"term":{"TEST_CountryArray.keyword":"UK"}}],"must_not":[],"should":[]}},"from":0,"size":10,"sort":[],"aggs":{}

}`
PFB for query result.
in terms query...

image
image.png1349×482 14.2 KB

..in Terms aggregation
image
image.png950×566 27.8 KB

can someone explain what could be the issue, and need any additional info.

Regards,
Srikanth

2

Could you provide a full recreation script as described in About the Elasticsearch category. It will help to better understand what you are doing. Please, try to keep the example as simple as possible.

A full reproduction script will help readers to understand, reproduce and if needed fix your problem. It will also most likely help to get a faster answer.

3

Thanks @dadoonet for the response. I am using NEST client from Dotnet to interact with ES and not much familiar with direct ES queries(I have posted the request output given by NEST). Can I share Nest code to get more details on this.

4

You can but I won't be able to help then.
Just open Kibana dev console and try to reproduce your problem without Nest and then we can see what is going wrong, how to fix, which you'll be able to translate to nest.

5

Hey @dadoonet..I just updated with full query information and screenshots from Kibana..can you please have a look and see where I am doing wrong.

6

By default you only get the top 10 terms (and the UK is not in that top ten).
Set the terms agg size parameter to a larger number to see more

7

Yeah. That really helped @Mark_Harwood. I was using global size parameter(size to specify docs count) that returns documents not terms. I just used size parameter for term it worked perfectly.

image
image.png743×229 15 KB

1 Like
8

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.