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
