You clearly need to escape those characters as for any other tool. You may want to use avro instead of csv , xml or JSON etc
> On 30 Oct 2015, at 19:16, Vijaya Narayana Reddy Bhoomi Reddy > <vijaya.bhoomire...@whishworks.com> wrote: > > Hi, > > I have a CSV file which contains hunderd thousand rows and about 200+ > columns. Some of the columns have free text information, which means it might > contain characters like comma, colon, quotes etc with in the column content. > > What is the best way to load such CSV file into Hive? > > Another serious issue, I have stored the file in a location in HDFS and then > created an external hive table on it. However, upon running Create external > table using HDP Hive View, the original CSV is no longer present in the > folder where it is meant to be. Not sure on how HDP processes and where it is > stored? My understanding was that EXTERNAL table wouldnt be moved from their > original HDFS location? > > Request someone to help out! > > > Thanks & Regards > Vijay > > > > The contents of this e-mail are confidential and for the exclusive use of the > intended recipient. If you receive this e-mail in error please delete it from > your system immediately and notify us either by e-mail or telephone. You > should not copy, forward or otherwise disclose the content of the e-mail. The > views expressed in this communication may not necessarily be the view held by > WHISHWORKS.