Re: Export to RDBMS directly

2013-07-17 Thread Siddharth Tiwari
I just want to confirm that it has not been > implemented in the latest Hive releases. > > Regards, > Omkar Joshi > > From: Bertrand Dechoux [mailto:decho...@gmail.com] > Sent: Thursday, July 18, 2013 10:43 AM > To: user@hive.apache.org > Subject: Re: Export to RDBMS

RE: Export to RDBMS directly

2013-07-17 Thread Omkar Joshi
: Thursday, July 18, 2013 10:43 AM To: user@hive.apache.org Subject: Re: Export to RDBMS directly The short answer is no. You could at the moment write your own input format/output format in order to do so. I don't know all the details for hive but that's possible. However, you will like

Re: Export to RDBMS directly

2013-07-17 Thread Bertrand Dechoux
The short answer is no. You could at the moment write your own input format/output format in order to do so. I don't know all the details for hive but that's possible. However, you will likely run a DOS against your database if you are not careful. Hive could embed sqoop in order do that smartly fo

Export to RDBMS directly

2013-07-17 Thread Omkar Joshi
Hi, Currently, I'm executing the following steps(Hadoop 1.1.2, Hive 0.11 and Sqoop-1.4.3.bin__hadoop-1.0.0) : 1.Import data from MySQL to Hive using Sqoop 2.Execute a query in Hive and store its output in a Hive table 3.Export the output to MySQL using Sqoop I was wondering if it