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 for you but that's not the case and I doubt that is it a feature planned in the short term. You have to manage yourself the steps (for which you could use a scheduler like Oozie).
Regards Bertrand On Thu, Jul 18, 2013 at 7:04 AM, Omkar Joshi <omkar.jo...@lntinfotech.com>wrote: > 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 would be possible to combine steps 2 & 3 – the > output of the Hive query written directly to the MySQL database. I read > about the external tables but couldn’t find an example where the LOCATION > clause points to something like > jdbc:myql://localhost:3306/<mysql-schema>/<some-mysql-table-name>. Is it > really possible?**** > > ** ** > > Regards,**** > > Omkar Joshi**** > > ** ** > > ------------------------------ > The contents of this e-mail and any attachment(s) may contain confidential > or privileged information for the intended recipient(s). Unintended > recipients are prohibited from taking action on the basis of information in > this e-mail and using or disseminating the information, and must notify the > sender and delete it from their system. L&T Infotech will not accept > responsibility or liability for the accuracy or completeness of, or the > presence of any virus or disabling code in this e-mail" > -- Bertrand Dechoux
