Details
-
Bug
-
Status: In Progress
-
Trivial
-
Resolution: Unresolved
-
2.1.1
-
None
-
None
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 ?