Re: Hive upload

2012-07-04 Thread Ruslan Al-Fakikh
> > ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' > STORED AS TEXTFILE > > > Regards > Bejoy KS > > ________ > From: Bejoy Ks > To: "user@hive.apache.org" > Sent: Wednesday, July 4, 2012 1:59 PM > Subject: Re: Hive

Re: Hive upload

2012-07-04 Thread Bejoy Ks
Sent: Wednesday, July 4, 2012 1:59 PM Subject: Re: Hive upload Hi Yogesh Looks like Sqoop import from rdbms to hdfs is getting successful but is failing at hive create table. You are seeing data in hive ware house because you have specified that as your target dir in sqoop import (--target-

Re: Hive upload

2012-07-04 Thread Bejoy Ks
___ From: yogesh dhari To: hive request Sent: Wednesday, July 4, 2012 1:40 PM Subject: RE: Hive upload Hi Bejoy, Thank you very much for your response, 1) A) When I run command  show tables it doesn't show  newhive table. B) Yes the the newhive directory is present into

RE: Hive upload

2012-07-04 Thread yogesh dhari
s data was imported from Mysql table)And what kind of confugration neede in sqoop Please suggest and help GreetingsYogesh Kumar Subject: Re: Hive upload To: user@hive.apache.org From: bejoy...@yahoo.com Date: Wed, 4 Jul 2012 05:58:41 + Hi Yogesh The first issue (sqoop one). 1) Is

Re: Hive upload

2012-07-03 Thread Bejoy KS
Hi Yogesh The first issue (sqoop one). 1) Is the table newhive coming when you list tables using 'show table'? 2) Are you seeing a directory 'newhive' in your hive warte house dir(usually /usr/hive/warehouse)? If not sqoop is failing to create hive tables /load data into them. Only sqoop import