[ https://issues.apache.org/jira/browse/HIVE-20520?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jesus Camacho Rodriguez updated HIVE-20520: ------------------------------------------- Attachment: HIVE-20520.02.patch > 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: Naresh P R > Assignee: Jesus Camacho Rodriguez > Priority: Major > Attachments: HIVE-20520.01.patch, HIVE-20520.02.patch, > HIVE-20520.02.patch, HIVE-20520.patch > > > 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)