Hi there,   Mi issue is very basic, I'm looking for the equivalent function in Hive of this SQL function =>  COLLATE SQL_Latin1_General_CP1_CI_AI It's very important for me because I work on towns like Sao Paulo which have different writing versions. I have an old topic regarding this subject on stackoverflow, which unfortunately didn't get any interesting answer....    Could you provide me help please ?   Best regards, Nicolas. ... View more