ElasticSearch [field_sort] unknown field [format]

Question

I'm adding a sort conditions field to my ElasticSearch query. I'm using ES 7.14 / Kibana 7.10. My sort array field look like

[
                    
    { "update_date": { "order": "desc", "missing" : "_last", "unmapped_type" : "long", "format": "strict_date_optional_time_nanos" } },
    { "release_date": { "order": "desc", "missing" : "_last", "unmapped_type" : "long", "format": "strict_date_optional_time_nanos" } }
]

where I have used: desc ordering, _last for missing values; long for unmapped_type, and strict_date_optional_time_nanos for format. The query builder complains that

node:15873) UnhandledPromiseRejectionWarning: Error: [x_content_parse_exception] [1:275] [field_sort] unknown field [format]

despite of the format field is available in ES 7.14. If I remove the format field, it works, but I have no control over the sorting fields I'm using. So how to specify the sorting fields format?

score 2 · Accepted Answer · answered Aug 20 '21 at 11:40

2

This is because the format parameter was released in 7.13 so your Kibana 7.10 doesn't know about it and hence complains when sending the query.

You should always keep your component versions in synch when upgrading to prevent incompatibilities such as the one you describe from happening.

So the solution is simple: upgrade Kibana to 7.14.

answered Aug 20 '21 at 11:40

Val

207,596
13
358
360

so even if I'm using `ES 7.14`? – loretoparisi Aug 20 '21 at 11:41
1

The error comes from Kibana, that's the weakest link – Val Aug 20 '21 at 11:41
ok it makes sense. Thanks, last question, just realized, possibly unrelated to this error: why the score value is `null` when applying the `sort` clausole? Is that ok? – loretoparisi Aug 20 '21 at 11:43
1

the score depends on your query, not the sorting. don't hesitate to create another question related to that different issue – Val Aug 20 '21 at 11:46
Posted it separately: https://stackoverflow.com/questions/68861970/elasticseach-score-field-is-null-when-sorting – loretoparisi Aug 20 '21 at 12:04

ElasticSearch [field_sort] unknown field [format]

1 Answers1