hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Winston Churchill (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-16083) Hive should escape fields terminator when use textfile format
Date Thu, 02 Mar 2017 02:03:45 GMT
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)

Mime
View raw message