I don't think there ever was a general-purpose SQLLOADER. It's just explaining the concept -- that if you want to, you can write one, and you aren't limited to reading from HDFS.
D On Tue, Jul 26, 2011 at 7:21 AM, Juan Martin Pampliega <[email protected] > wrote: > 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 > > > > > > > > > > >
