[ https://issues.apache.org/jira/browse/HIVE-11855?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15373396#comment-15373396 ]
Vihang Karajgaonkar commented on HIVE-11855: -------------------------------------------- I tried adding the fields like given in the summary and it showing the expected results. Can you confirm if this is happening with the latest beeline? {noformat} $ cat /tmp/test.txt 200 value1^Mvalue2 0: jdbc:hive2://localhost:10000> desc test; +-----------+------------+----------+--+ | col_name | data_type | comment | +-----------+------------+----------+--+ | id | int | | | value | string | | +-----------+------------+----------+--+ 2 rows selected (0.075 seconds) 0: jdbc:hive2://localhost:10000> load data local inpath '/tmp/test.txt' into table test; No rows affected (0.262 seconds) 0: jdbc:hive2://localhost:10000> select * from test; +----------+-----------------+--+ | test.id | test.value | +----------+-----------------+--+ | 200 | value1^Mvalue2 | +----------+-----------------+--+ 1 row selected (0.123 seconds) {noformat} > Beeline display is not correct when content contains invisible character like > \r > -------------------------------------------------------------------------------- > > Key: HIVE-11855 > URL: https://issues.apache.org/jira/browse/HIVE-11855 > Project: Hive > Issue Type: Bug > Components: Beeline > Affects Versions: 1.1.1, 1.2.1 > Reporter: Victor JMelo > Priority: Minor > > Field content like this: > {quote} > col1_part1^Mcol1_part2 > {quote} > create table statement: > {quote} > create table foo(c1 string); > {quote} > After load the data into table foo using sqoop, beeline displays: > {quote} > 0: jdbc:hive2://localhost:10000/default> select * from foo; > +-------------------------+ > | foo.c1 | > +-------------------------+ > col1_part2t1 > | > +-------------------------+ > {quote} > The first part of the data "col1_part1" is overwritten by the second part > "col1_part2" -- This message was sent by Atlassian JIRA (v6.3.4#6332)