Alternatively you could write a simple script to convert the csv to a pipe delimited file so that "abc,def" will be abc,def.
On Jun 26, 2012, at 2:51 PM, Harsh J wrote: > Hive's delimited-fields-format record reader does not handle quoted > text that carry the same delimiter within them. Excel supports such > records, so it reads it fine. > > You will need to create your table with a custom InputFormat class > that can handle this (Try using OpenCSV readers, they support this), > instead of relying on Hive to do this for you. If you're successful in > your approach, please also consider contributing something back to > Hive/Pig to help others. > > On Wed, Jun 27, 2012 at 12:37 AM, Sandeep Reddy P > <[email protected]> wrote: >> >> >> Hi all, >> I have a csv file with 46 columns but i'm getting error when i do some >> analysis on that data type. For simplification i have taken 3 columns and >> now my csv is like >> c,zxy,xyz >> d,"abc,def",abcd >> >> i have created table for this data using, >> hive> create table test3( >> > f1 string, >> > f2 string, >> > f3 string) >> > row format delimited >> > fields terminated by ","; >> OK >> Time taken: 0.143 seconds >> hive> load data local inpath '/home/training/a.csv' >> > into table test3; >> Copying data from file:/home/training/a.csv >> Copying file: file:/home/training/a.csv >> Loading data to table default.test3 >> OK >> Time taken: 0.276 seconds >> hive> select * from test3; >> OK >> c zxy xyz >> d "abc def" >> Time taken: 0.156 seconds >> >> When i do select f2 from test3; >> my results are, >> OK >> zxy >> "abc >> but this should be abc,def >> When i open the same csv file with Microsoft Excel i got abc,def >> How should i solve this error?? >> >> >> >> -- >> Thanks, >> sandeep >> >> -- >> >> >> > > > > -- > Harsh J >
