question How can I remove accents from a string in Impala? in Support Questions

question How can I remove accents from a string in Impala? in Support Questions https://community.cloudera.com/t5/Support-Questions/How-can-I-remove-accents-from-a-string-in-Impala/m-p/79202#M13119 For example: Assume I have the following string: "Gánémílózú" I need the query to return "Ganemilozu" (without the accents) I've tried to use the <A href="https://www.cloudera.com/documentation/enterprise/5-14-x/topics/impala_string_functions.html" target="_blank">translate</A> function, as follows:  <PRE>SELECT translate('Gánémílózú', 'áéíóú', 'aeiou') FROM (SELECT 1) as dual;</PRE>But it returns "Gaenaomalaza". Apparently I didn't understand the translate function. Can anyone explain why doesn't my approach work or lead me to a possible solution to remove the accents? Thanks in advance! EDIT: I found that the problem lies not in the translate function but in the handling of accents by Impala. The translation: <PRE>SELECT translate('Gánémílózú', 'Gnmlz', '12345') FROM (SELECT 1) as dual;</PRE>Works perfectly fine by returning 1á2é3í4ó5ú Does anyone know how does Impala handle characters with accents?  Fri, 16 Sep 2022 13:38:59 GMT jgutierrezh 2022-09-16T13:38:59Z