Our Community is getting an upgrade! To get everything ready for the relaunch, we’ll be placing the site in read-only mode starting September 21st.
We really appreciate your understanding while we get things set up behind the scenes. Catch up on all the exciting details about the move here.
Need help or have questions? Drop us a line at [email protected]
Created 06-07-2017 07:18 PM
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.
Created 06-08-2017 01:36 PM
It appears that this is expected behavior.
I discovered a jira pertaining to it here: https://issues.apache.org/jira/browse/HIVE-13865
Created 06-08-2017 12:00 AM
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.
Created 06-08-2017 01:36 PM
It appears that this is expected behavior.
I discovered a jira pertaining to it here: https://issues.apache.org/jira/browse/HIVE-13865
Created 06-09-2017 10:31 AM
Good to know this.