You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@pig.apache.org by Ranjith <ra...@gmail.com> on 2012/09/11 00:26:56 UTC

loading data to mysql using pig

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?

Re: loading data to mysql using pig

Posted by Ruslan Al-Fakikh <me...@gmail.com>.
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 <ra...@gmail.com> 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?