hadoop-common-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sandeep Reddy P <sandeepreddy.3...@gmail.com>
Subject Hive error when loading csv data.
Date Tue, 26 Jun 2012 19:07:46 GMT
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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message