I have noticed an issue in Hive 1.2 where char data is rtrimmed when converted to string. This doesn't occur when converting varchar to string. Is this a bug? or a feature?
select length(cast('abc ' as char(10))), length(cast('abc ' as varchar(10))), length(cast('abc ' as string)); _c0,_c1,_c2 3,7,7
In the above example I would expect the length of the char field to be 10.
Looks like it's a bug, because the Char always fixed length. In this case you have declared it as char(10), even though you have only 3 chars assigned it to, it should not truncate the rest.