Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Plain View
Pig >> mail # user >> MySQL / JDBC / SQL DB Loader?


+
Anze 2010-11-03, 07:22
Copy link to this message
-
Re: MySQL / JDBC / SQL DB Loader?
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
>
+
Anze 2010-11-03, 08:56
+
Sonal Goyal 2010-11-03, 09:27
+
Anze 2010-11-03, 11:32
+
Ankur C. Goel 2010-11-03, 14:18
+
Jai Krishna 2010-11-04, 11:38
+
Anze 2010-11-04, 12:30
+
arvind@...) 2010-11-03, 17:08
+
Anze 2010-11-03, 19:08
+
arvind@...) 2010-11-03, 19:17
+
Anze 2010-11-04, 09:26
+
arvind@...) 2010-11-04, 16:25
+
arvind@...) 2010-11-04, 16:29
+
Anze 2010-11-04, 20:02
+
Dmitriy Ryaboy 2010-11-04, 22:22
+
Aaron Kimball 2010-11-04, 23:16
+
Anze 2010-11-05, 13:42
+
Aaron Kimball 2010-11-05, 17:24
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB