I am trying to use elasticsearch-analysis-icu plugin to achieve case-insensitivity sort, data is getting sorted correctly but its returning data in china language for both sort field in queries and aggregation bucket. Is there any way to get it in English?

I see. So here is a trick. Run a first level of terms agg on a lowercased field (like name.lower). Then run a sub agg on the normal field (like name). As a result you will get all buckets ordered by lowercased name but you will get the actual value from the sub aggregation result.

Discuss the Elastic Stack

Issue with elasticsearch-analysis-icu plugin

Elastic Stack Elasticsearch

Topic		Replies	Views
Is case-insensitive sort on keyword aggregation possible ? (ES 6.4) Elasticsearch	5	2783	October 19, 2018
multi_field and sort Elasticsearch	7	753	December 15, 2011
Multi-lingual ES Elasticsearch	8	1289	August 5, 2013
Sort Chinese error Elasticsearch	10	1954	February 15, 2012
ICU, collation, and numbers Elasticsearch	2	664	December 2, 2015

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.

Issue with elasticsearch-analysis-icu plugin

Related topics