[ https://issues.apache.org/jira/browse/HIVE-20520?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Work on HIVE-20520 started by Jesus Camacho Rodriguez. ------------------------------------------------------ > length(CHAR) doesn't consider trailing space > -------------------------------------------- > > Key: HIVE-20520 > URL: https://issues.apache.org/jira/browse/HIVE-20520 > Project: Hive > Issue Type: Bug > Components: UDF > Reporter: Jesus Camacho Rodriguez > Assignee: Jesus Camacho Rodriguez > Priority: Major > > Reproduce steps: > {code:java} > create table test(a char(2), b varchar(2)); > insert into test values('L ', 'L '); > select length(a),length(b) from test; > +------+------+ > | _c0 | _c1 | > +------+------+ > | 1 | 2 | > +------+------+ > 1 row selected (0.185 seconds) > {code} > Here char with trailing spaces are trimmed, whereas leading spaces are not > trimmed. -- This message was sent by Atlassian JIRA (v7.6.3#76005)