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?