I have a strange issue, on our CDH 5.10.2 Cluster using lpad or rpad on hive with special characters returns wrong results.
select length(lpad("è",50,' '));
result is 49 and obviously should be 50
select length(lpad("e",50,' '));
result is correctly 50, so if special characters are involved lpad and rpad gives wrong results.
I'm I missing something? or is it a bug
LANG is setted to UTF8