https://community.cloudera.com/t5/Support-Questions/How-can-I-remove-accents-from-a-string-in-Impala/m-p/79233#M13121 <P>Thanks for clarifying that translate only works on ASCII characters.&nbsp;</P><P>&nbsp;</P><P>I found a similar solution to the one you proposed, using the replace function instead of the regexp replace. However, as you mention, the solution is really not scalable and it is very tedious to implement and maintain.&nbsp;</P> Thu, 30 Aug 2018 16:09:26 GMT jgutierrezh 2018-08-30T16:09:26Z