in Hive one of the column have data like below how can i remove special delimiter in column data.
My dataset set is as below:
704,“Quest, The (1996)”,Action|Adventure
747,“Stupids, The (1996)”,Comedy
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 ?
Could you please elaborate to resolve this issue.