Anze, Did you get a chance to try out Sqoop? If not, I would encourage you to do so. Here is a link to the user guide<http://archive.cloudera.com/cdh/3/sqoop/SqoopUserGuide.html> .
Sqoop allows you to easily move data across from relational databases and other enterprise systems to HDFS and back. Arvind 2010/11/3 Anze <[email protected]> > > Alejandro, thanks for answering! > > I was hoping it could be done directly from Pig, but... :) > > I'll take a look at Sqoop then, and if that doesn't help, I'll just write a > simple batch to export data to TXT/CSV. Thanks for the pointer! > > Anze > > > On Wednesday 03 November 2010, Alejandro Abdelnur wrote: > > Not a 100% Pig solution, but you could use Sqoop to get the data in as a > > pre-processing step. And if you want to handle all as single job, you > could > > use Oozie to create a workflow that does Sqoop and then your Pig > > processing. > > > > Alejandro > > > > On Wed, Nov 3, 2010 at 3:22 PM, Anze <[email protected]> wrote: > > > Hi! > > > > > > Part of data I have resides in MySQL. Is there a loader that would > allow > > > loading directly from it? > > > > > > I can't find anything on the net, but it seems to me this must be a > quite > > > common problem. > > > I checked piggybank but there is only DBStorage (and no DBLoader). > > > > > > Is some DBLoader out there too? > > > > > > Thanks, > > > > > > Anze > >
