Re: Postgres JDBC + dboutput UDF to export from Hive to remote Postgres

2012-04-09 Thread Abhishek Parolkar
t;> Regards > >> Bejoy KS > >> > >> Sent from handheld, please excuse typos. > >> > >> From: Abhishek Parolkar > >> Date: Thu, 29 Mar 2012 16:25:08 +0800 > >> To: > >> ReplyTo: user@hive.apache

Re: Postgres JDBC + dboutput UDF to export from Hive to remote Postgres

2012-03-30 Thread Abhishek Parolkar
: > >> > >> Hi Abshiek > >> To transfer data between rdbms and hadoop Sqoop is the preferred and > >> recommended option. Once you have the process done in hive the output > data > >> can be exported to PG with sqoop export command. > >> Regards >

Re: Postgres JDBC + dboutput UDF to export from Hive to remote Postgres

2012-03-30 Thread Bejoy Ks
ut data >>> can be exported to PG with sqoop export command. >>> Regards >>> Bejoy KS >>> >>> Sent from handheld, please excuse typos. >>> ________________ >>> From: Abhishek Parolkar >>> Date: Thu, 29 Mar 201

Re: Postgres JDBC + dboutput UDF to export from Hive to remote Postgres

2012-03-30 Thread Bejoy Ks
To: user@hive.apache.org Sent: Friday, March 30, 2012 1:33 PM Subject: Re: Postgres JDBC + dboutput UDF to export from Hive to remote Postgres forgot to add the sceenshot in last email :) On Fri, Mar 30, 2012 at 4:02 PM, Abhishek Parolkar wrote: I even tried sqoop, but with no luck. It

Re: Postgres JDBC + dboutput UDF to export from Hive to remote Postgres

2012-03-30 Thread Abhishek Parolkar
ted to PG with sqoop export command. >> >> Regards >> >> Bejoy KS >> >> >> >> Sent from handheld, please excuse typos. >> >> >> >> From: Abhishek Parolkar >> >> Date: Thu, 29 Mar 201

Re: Postgres JDBC + dboutput UDF to export from Hive to remote Postgres

2012-03-29 Thread Abhishek Parolkar
s done in hive the output > data > >> can be exported to PG with sqoop export command. > >> Regards > >> Bejoy KS > >> > >> Sent from handheld, please excuse typos. > >> ____________ > >> From: Abhishek Parolkar > >

Re: Postgres JDBC + dboutput UDF to export from Hive to remote Postgres

2012-03-29 Thread Edward Capriolo
___ >> From: Abhishek Parolkar >> Date: Thu, 29 Mar 2012 16:25:08 +0800 >> To: >> ReplyTo: user@hive.apache.org >> Subject: Postgres JDBC + dboutput UDF to export from Hive to remote >> Postgres >> >> Hi There, >>   I

Re: Postgres JDBC + dboutput UDF to export from Hive to remote Postgres

2012-03-29 Thread Abhishek Parolkar
th sqoop export command. > Regards > Bejoy KS > > Sent from handheld, please excuse typos. > -- > *From: * Abhishek Parolkar > *Date: *Thu, 29 Mar 2012 16:25:08 +0800 > *To: * > *ReplyTo: * user@hive.apache.org > *Subject: *Postgres JDBC

Re: Postgres JDBC + dboutput UDF to export from Hive to remote Postgres

2012-03-29 Thread Bejoy KS
- From: Abhishek Parolkar Date: Thu, 29 Mar 2012 16:25:08 To: Reply-To: user@hive.apache.org Subject: Postgres JDBC + dboutput UDF to export from Hive to remote Postgres Hi There, I am trying to get dboutput() UDF to work so that it can write result to a PG DB table. ==This is what I did in

Postgres JDBC + dboutput UDF to export from Hive to remote Postgres

2012-03-29 Thread Abhishek Parolkar
Hi There, I am trying to get dboutput() UDF to work so that it can write result to a PG DB table. ==This is what I did in hive shell== add jar /location/hive_contrib.jar; add jar /location/postgresql9jdbc3.jar; set jdbc.drivers = org.postgresql.Driver; CREATE TEMPORARY FUNCTION dboutpu