Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
MapReduce >> mail # user >> Saving data in db instead of hdfs

Copy link to this message
Re: Saving data in db instead of hdfs

just use Sqoop to push the data from HDFS to a database via JDBC.

Intro to Sqoop:

Or even use Hive-JDBC to connect to your result data from outside the
hadoop cluster.

You can also create your own OutputFormat (with Java API), which writes
data directly to the database, but be careful
with large result sets or even with a large number of reducers. This could
be a scalability issue, but a small
dataset coming out from one reducer can be handled that way.

OutputFormat and Streaming API:

Best wishes
2013/5/2 Chengi Liu <[EMAIL PROTECTED]>

> Hi,
>  I am using hadoop streaming api (python) for some processing.
> While I want the data to be processed via hadoop but I want to pipe it to
> db instead of hdfs.
> How do I do this?
> THanks