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
