Make sure you have set the table properties while creating the table
structure.
Also , it should not be a problem unless it is a FixedLength.Try altering
the table to set it to the type desired or else it will be by default
SequenceFile
On Tue, Sep 24, 2013 at 7:51 PM, Artem Ervits wrote:
> A
apache.org>
Subject: Re: load data stored as sequencefiles
If you look at your load command,
LOAD DATA INPATH '/TEST/SeqFiles/201308300700/part-m-1' INTO TABLE tblname;
you are loading a part file which does not look correct.
Secondly,
Why can't you just import using sqoop.
a way to take those
sequencefiles and load them into a hive table?
Thanks.
From: Nitin Pawar [mailto:nitinpawar...@gmail.com]
Sent: Tuesday, September 24, 2013 12:00 PM
To: user@hive.apache.org
Subject: Re: load data stored as sequencefiles
If you look at your load command,
LOAD DATA INPATH &
If you look at your load command,
LOAD DATA INPATH '/TEST/SeqFiles/201308300700/part-m-1' INTO TABLE
tblname;
you are loading a part file which does not look correct.
Secondly,
Why can't you just import using sqoop. Why you have to do load data?
If you are importing to hdfs using sqoop, and t
Anyone?
From: Artem Ervits [mailto:are9...@nyp.org]
Sent: Friday, September 20, 2013 11:18 AM
To: user@hive.apache.org
Subject: load data stored as sequencefiles
Hello all,
I'm a bit lost with using Hive and SequenceFiles. I loaded data using Sqoop
from a RDBMS and stored as sequencefile. I jar
