[
https://issues.apache.org/jira/browse/HIVE-9537?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14328966#comment-14328966
]
Aihua Xu commented on HIVE-9537:
--------------------------------
[~the6campbells] I didn't exactly follow your point. Are you recommending
improving the documentation or some sort of enhancement? Based on my
understanding, fixed length CHAR(n) is more efficient than varchar. The
behavior of fixed length is, the padding trailing spaces won't be counted as
part of the string.
I do see an issue that if we insert a string with trailing spaces "abc " into
CHAR(10), we lost the last space. I think that's an issue since that trailing
space is part of the original string.
What does this mean? "If both operands are fixed length character strings,
concatenation result is a fixed length character string with a length equal to
the sum of the lengths of the operands where the length cannot exceed the
maximum allowed for a fixed length character string."
> 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)
