My dataset set is as below: 700,Angus (1995),Comedy 702,Faces (1968),Drama 703,Boys (1996),Drama 704,"Quest, The (1996)",Action|Adventure 705,Cosi (1996),Comedy 747,"Stupids, The (1996)",Comedy Create table movies(
movieid int,
title String,
genre string)
row format delimited
fields terminated by ','
;
Select title , genre from movies;
Since the rows have comma separated values, the records like 704,"Quest, The (1996)",Action|Adventure returns Quest as title, instead of Quest,The (1996). And Genre value is shown as The(1996) instead of Action|Adventure. How to load such data correctly by escaping the delimiter in the value ?
... View more
