Skip to content

Exception when sorting on geo_point #1933

@dadoonet

Description

@dadoonet

By mistake, I clicked on the sort button on a geo_point column.

kibana 4 google chrome aujourd hui at 10 50 26

Which leads me to this error:

Segmented Fetch: SearchPhaseExecutionException[Failed to execute phase [query], all shards failed; shardFailures {[ac-m7BnNQeSQSbe8OGl-vA][person][0]: SearchParseException[[person][0]: from[-1],size[500]: Parse Failure [Failed to parse source [{"size":500,"sort":{"address.location":"desc"},"aggs":{"agg_25":{"date_histogram":{"field":"dateOfBirth","interval":"31536000000ms","min_doc_count":0,"extended_bounds":{"min":"1939-12-31T23:00:00.000Z","max":"2010-12-31T23:00:00.000Z"}}}},"query":{"filtered":{"query":{"match_all":{}},"filter":{"bool":{"must":[{"range":{"dateOfBirth":{"gte":-946774800000,"lte":1293836400000}}}],"must_not":[]}}}}}]]]; nested: ElasticsearchIllegalArgumentException[can't sort on geo_point field without using specific sorting feature, like geo_distance]; }{[ac-m7BnNQeSQSbe8OGl-vA][person][1]: SearchParseException[[person][1]: from[-1],size[500]: Parse Failure [Failed to parse source [{"size":500,"sort":{"address.location":"desc"},"aggs":{"agg_25":{"date_histogram":{"field":"dateOfBirth","interval":"31536000000ms","min_doc_count":0,"extended_bounds":{"min":"1939-12-31T23:00:00.000Z","max":"2010-12-31T23:00:00.000Z"}}}},"query":{"filtered":{"query":{"match_all":{}},"filter":{"bool":{"must":[{"range":{"dateOfBirth":{"gte":-946774800000,"lte":1293836400000}}}],"must_not":[]}}}}}]]]; nested: ElasticsearchIllegalArgumentException[can't sort on geo_point field without using specific sorting feature, like geo_distance]; }{[ac-m7BnNQeSQSbe8OGl-vA][person][2]: SearchParseException[[person][2]: from[-1],size[500]: Parse Failure [Failed to parse source [{"size":500,"sort":{"address.location":"desc"},"aggs":{"agg_25":{"date_histogram":{"field":"dateOfBirth","interval":"31536000000ms","min_doc_count":0,"extended_bounds":{"min":"1939-12-31T23:00:00.000Z","max":"2010-12-31T23:00:00.000Z"}}}},"query":{"filtered":{"query":{"match_all":{}},"filter":{"bool":{"must":[{"range":{"dateOfBirth":{"gte":-946774800000,"lte":1293836400000}}}],"must_not":[]}}}}}]]]; nested: ElasticsearchIllegalArgumentException[can't sort on geo_point field without using specific sorting feature, like geo_distance]; }{[ac-m7BnNQeSQSbe8OGl-vA][person][3]: SearchParseException[[person][3]: from[-1],size[500]: Parse Failure [Failed to parse source [{"size":500,"sort":{"address.location":"desc"},"aggs":{"agg_25":{"date_histogram":{"field":"dateOfBirth","interval":"31536000000ms","min_doc_count":0,"extended_bounds":{"min":"1939-12-31T23:00:00.000Z","max":"2010-12-31T23:00:00.000Z"}}}},"query":{"filtered":{"query":{"match_all":{}},"filter":{"bool":{"must":[{"range":{"dateOfBirth":{"gte":-946774800000,"lte":1293836400000}}}],"must_not":[]}}}}}]]]; nested: ElasticsearchIllegalArgumentException[can't sort on geo_point field without using specific sorting feature, like geo_distance]; }{[ac-m7BnNQeSQSbe8OGl-vA][person][4]: SearchParseException[[person][4]: from[-1],size[500]: Parse Failure [Failed to parse source [{"size":500,"sort":{"address.location":"desc"},"aggs":{"agg_25":{"date_histogram":{"field":"dateOfBirth","interval":"31536000000ms","min_doc_count":0,"extended_bounds":{"min":"1939-12-31T23:00:00.000Z","max":"2010-12-31T23:00:00.000Z"}}}},"query":{"filtered":{"query":{"match_all":{}},"filter":{"bool":{"must":[{"range":{"dateOfBirth":{"gte":-946774800000,"lte":1293836400000}}}],"must_not":[]}}}}}]]]; nested: ElasticsearchIllegalArgumentException[can't sort on geo_point field without using specific sorting feature, like geo_distance]; }]

I think we should not allow sorting on such a column.

Metadata

Metadata

Assignees

Labels

PR sentbugFixes for quality problems that affect the customer experience

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions