Re: Best way to load CSV file into Hive

2015-10-31 Thread Peyman Mohajerian
if you find a way to escape the characters, some pre-processing step then you may find this useful: https://cwiki.apache.org/confluence/display/Hive/CSV+Serde On Fri, Oct 30, 2015 at 11:36 AM, Martin Menzel wrote: > Hi > Do have access to the data source? > If not you have first to find out if t

Re: Best way to load CSV file into Hive

2015-10-31 Thread Jörn Franke
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 > wrote: > > Hi, > > I have a CSV file which contains hunderd thousand rows and about 200+ > columns. So