Re: Storing Pig Output in a Database

[Pratyush Banerjee]

Hi Satish,

There are two ways to do your job.

1.  Dump your results into a file in HDFS as the records in the table 
would look like, and then do a load in file directly from the file to 
the MySql table
2. Create a UDF to dump your results directly into a database. For 
writing this UIDF you would need to implement the StoreFunc class.

Refer to the UDF 
Manual(http://hadoop.apache.org/pig/docs/r0.3.0/udf.html) in the apache 
Pig website for further details on how to implement the same.

Thanks and regards,
Pratyush Banerjee

V Satish Kumar wrote:

I would like the output from my pig task to be stored in a mysql 
database.
Is there a way of storing this pig output directly into a mysql database?


Thanks,
Satish