[HIVE-16083] Hive should escape fields terminator when use textfile format

• Type: Bug
• Status: In Progress
• Priority: Trivial
• Resolution: Unresolved
• Affects Version/s: 2.1.1
• Component/s: File Formats
• Assignee: Anoop S Nair
• Reporter: Winston Churchill
• Created: 02/Mar/17 02:03
• Updated: 29/May/17 18:55

Description

Create table with comon as fields terminator and insert data contains comon:

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')；

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

May need to escape the fields terminator ?