About jgutierrezh

jgutierrezh · ‎08-30-2018

Thanks for clarifying that translate only works on ASCII characters. 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.

jgutierrezh · ‎08-29-2018

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 translate function, as follows: SELECT translate('Gánémílózú', 'áéíóú', 'aeiou') FROM (SELECT 1) as dual; 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: SELECT translate('Gánémílózú', 'Gnmlz', '12345') FROM (SELECT 1) as dual; Works perfectly fine by returning 1á2é3í4ó5ú Does anyone know how does Impala handle characters with accents?

Online	Offline
Last Visited	‎10-12-2018 03:43 PM

Member Since	‎08-29-2018 12:48 PM
Last Visited	‎10-12-2018 03:43 PM
Posts	2
Kudos received	1

Cloudera Community

Re: How can I remove accents from a string in Impa...

How can I remove accents from a string in Impala?