[HIVE-9537] string expressions on a fixed length character do not preserve trailing spaces

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Not A Problem
• Component/s: SQL
• Assignee: Aihua Xu
• Reporter: N Campbell
• Created: 31/Jan/15 15:01
• Updated: 09/Mar/15 17:52
• Resolved: 09/Mar/15 17:52

Description

When a string expression such as upper or lower is applied to a fixed length column the trailing spaces of the fixed length character are not preserved.

CREATE TABLE  if not exists TCHAR ( 
RNUM int, 
CCHAR char(32)    
)
ROW FORMAT DELIMITED 
FIELDS TERMINATED BY '|' 
LINES TERMINATED BY '\n' 
STORED AS TEXTFILE;

cchar as a char(32).

select cchar, concat(cchar, cchar), concat(lower(cchar), cchar), concat(upper(cchar), cchar) 
from tchar;

0|\N
1|
2|
3|BB
4|EE
5|FF

Issue Links

• relates to: HIVE-9899 Update the document for fixed length of char data type