On Thu, Oct 8, 2009 at 3:16 PM, Vijay <[email protected]> wrote: > Is there any built-in support using Hive or any of the underlying output > format support to insert Hive query results directly into a mysql database? > For example if I want to directly load some aggregate results from a hive > query into a separate database. Sorry if this has been discussed elsewhere; > I couldn't find it easily. > > Thanks, > Vijay >
Vijay, Check out. dboutputformat UDF. It is in the trunk contrib. http://mail-archives.apache.org/mod_mbox/hadoop-hive-commits/200908.mbox/%[email protected]%3e It has some caveats but if it fits your need it is super easy. Someone at Cloudera is also working on unsqoop hive->database. Edward
