I found about in the PigLatin manual. http://pig.apache.org/docs/r0.8.1/piglatin_ref1.html#Backward+Compatibility
But maybe it is deprecated as there is no reference in the Java Doc. On Tue, Jul 26, 2011 at 10:11 AM, Jacob Perkins <[email protected]>wrote: > You might also take a look at > > > http://pig.apache.org/docs/r0.8.1/api/index.html?org/apache/pig/piggybank/storage/DBStorage.html > > which is going to require that you 'register' the piggybank jar. I'm not > entirely sure that's what you're looking for either though. > > I'm curious, in the same java doc I see no reference to SQLLOADER, where > did you find that? > > --jacob > @thedatachef > > On Tue, 2011-07-26 at 10:00 -0300, Juan Martin Pampliega wrote: > > From what I read, data from a RDBMS is read by the command: > > LOAD 'sql://mytable' USING SQLLOADER(); > > > > I couldn't find any info on how the connection parameters to the database > > are passed and which databases are supported. > > > > On Tue, Jul 26, 2011 at 7:40 AM, Mance Rylan <[email protected]> > wrote: > > > > > Hi, > > > > > > I have googled a lot about if I can have Pig interact with an RDBMS. > > > Is there any way to have Pig load data from an rdbms? perform some > > > operations and then store data on Hadoop? > > > > > > Thanks, > > > Mance > > > > > >
