Winston Churchill created HIVE-16083:
----------------------------------------

             Summary: Hive should escape fields terminator when use textfile 
format
                 Key: HIVE-16083
                 URL: https://issues.apache.org/jira/browse/HIVE-16083
             Project: Hive
          Issue Type: Bug
          Components: File Formats
    Affects Versions: 2.1.1
            Reporter: Winston Churchill
            Priority: Trivial


Create table with comon as fields terminator and insert data contains comon:
{code}
create table test_1(id int,name string) row format delimited fields terminated 
by ',' stored as textfile;
insert into table test_1 values (1,'a,b,c');
{code}

{code}
select * from test_1;
+------------+--------------+--+
| test_1.id  | test_1.name  |
+------------+--------------+--+
| 1          | a            |
+------------+--------------+--+
4 rows selected (0.363 seconds)
{code}

May need to escape the fields terminator ?



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Reply via email to