[jira] [Commented] (HIVE-11855) Beeline display is not correct when content contains invisible character like \r

["Vihang Karajgaonkar (JIRA)" <ji...@apache.org>]

    [ 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)