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 Threaded View
Pig >> mail # user >> loading data to mysql using pig


Copy link to this message
-
Re: loading data to mysql using pig
Hi,

Probably DBStorage is more convenient (I haven't tried it), but you
can also you Sqoop if you are ok with storing data to HDFS first and
then using Sqoop to insert data to MySql

Ruslan

On Tue, Sep 11, 2012 at 2:26 AM, Ranjith <[EMAIL PROTECTED]> wrote:
> Question for you pig experts.....Trying to determine the best way of inserting data into mysql using pig. Is DBStorage the best way to perform this? I have also read about denial of service attacks that one needs to be careful of......Can we minimize this risk by setting hadoop parameters limiting the number of mappers?
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