Re: MySQL or JDBC StoreFunc?

[Ian Holsman]

I contributed the code in
https://issues.apache.org/jira/browse/PIG-1229

and Ankur has promised to get it in shape to be contributed.


ps.. thanks to Ankur & Sean for pinging me directly.. I missed this 
thread ;-)

On 2/8/10 7:02 PM, Ankur C. Goel wrote:
A while back, Ian Holsman developed a StoreFunc UDF to write to MySQL DB 
directly from Hadoop.
Hopefully, he is listening and is in a position to contribute this to piggybank 
:-)

Regards
-...@nkur

On 2/7/10 7:14 PM, "Jeff Zhang"<zjf...@gmail.com>  wrote:

Hi Anthony,

Pig is integrating hadoop's InputFormat and OutputFormat
(Pig-966<https://issues.apache.org/jira/browse/PIG-966>).
After this jira is done, it is easy to implement JDBC loadfunc and
storefunc, just using DBInputFormat and DBOutputFormat


On Sun, Feb 7, 2010 at 4:24 AM, Anthony Urso<antho...@cs.ucla.edu>  wrote:

   
Anyone have an implementation or ideas towards a StoreFunc for JDBC or
MySQL?

It looks like I would need to spawn a thread to read the InputStream
and reparse the tuples.  Overall, it sounds a little unappealing.

Thanks for any advice,
Anthony

     


--
Best Regards

Jeff Zhang