[
https://issues.apache.org/jira/browse/HIVE-9537?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14329581#comment-14329581
]
Aihua Xu commented on HIVE-9537:
--------------------------------
[~the6campbells] Are you satisfied with the explanation? This is considered to
by design. If you are concerned about the documentation, I will find out how to
get it updated to reflect your point and trailing space. Let me know.
> string expressions on a fixed length character do not preserve trailing spaces
> ------------------------------------------------------------------------------
>
> Key: HIVE-9537
> URL: https://issues.apache.org/jira/browse/HIVE-9537
> Project: Hive
> Issue Type: Bug
> Components: SQL
> Reporter: N Campbell
> Assignee: Aihua Xu
>
> 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.
> {code:sql}
> CREATE TABLE if not exists TCHAR (
> RNUM int,
> CCHAR char(32)
> )
> ROW FORMAT DELIMITED
> FIELDS TERMINATED BY '|'
> LINES TERMINATED BY '\n'
> STORED AS TEXTFILE;
> {code}
> {{cchar}} as a {{char(32)}}.
> {code:sql}
> select cchar, concat(cchar, cchar), concat(lower(cchar), cchar),
> concat(upper(cchar), cchar)
> from tchar;
> {code}
> 0|\N
> 1|
> 2|
> 3|BB
> 4|EE
> 5|FF
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
