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
