Hi, I haven't used DBStorage yet but I have developed my own database export/import classes. You can find source codes and binaries in here: http://static.jurfa.com/piql.tar.gz
You can also use these classes with their main methods from console. I hope it helped you. On Sat, Jan 14, 2012 at 11:35 AM, rakesh sharma <[email protected] > wrote: > > It works fine when there is only one store statement in pig script. > However, no data gets loaded in the database when there is more than one > store statement (loading two different sets of data in different tables). > Any ideas? > > > Date: Tue, 10 Jan 2012 15:38:23 -0800 > > Subject: Re: Oracle as Pig data store > > From: [email protected] > > To: [email protected] > > > > > http://pig.apache.org/docs/r0.8.1/api/org/apache/pig/piggybank/storage/DBStorage.html > > > > Warning: this might effectively DDOS your database. > > > > On Tue, Jan 10, 2012 at 2:12 PM, Russell Jurney > > <[email protected]> wrote: > > > I'd be interested in how to do this for MySQL or another JDBC > connection. > > > > > > Russell Jurney > > > twitter.com/rjurney > > > [email protected] > > > datasyndrome.com > > > > > > On Jan 10, 2012, at 1:39 PM, rakesh sharma < > [email protected]> wrote: > > > > > >> > > >> Hi All, > > >> What is the best way of pushing pig MR output to oracle DB? I would > appreciate if a working example can be provided. > > >> Thanks,RS > >
