Re: load data stored as sequencefiles

2013-09-24 Thread Swagatika Tripathy
: > 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

RE: load data stored as sequencefiles

2013-09-24 Thread Artem Ervits
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.

RE: load data stored as sequencefiles

2013-09-24 Thread Artem Ervits
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 &

Re: load data stored as sequencefiles

2013-09-24 Thread Nitin Pawar
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 sequen

RE: load data stored as sequencefiles

2013-09-24 Thread Artem Ervits
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 sequencefi

load data stored as sequencefiles

2013-09-20 Thread Artem Ervits
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 jarred the class generated by sqoop and added it to my create table script. Now I create a table in hive and specify "STORED AS SEQUENCEFILE", I also "ADD JAR SQOOP_