You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@pig.apache.org by Mandeep Sihag <ma...@googlemail.com> on 2014/05/21 11:08:42 UTC
DBStorage for loading data from mysql
Hi,
I want to take input from mysql database, I can see that there is a
DBStorage class for storing the output on database, but couldn't find the
implementation for loading data from mysql. Can somebody help.
--
Mandeep Singh
Re: DBStorage for loading data from mysql
Posted by Mandeep Sihag <ma...@googlemail.com>.
Yeah, that's true but was just wondering can not one write DBLoader?
On Thu, May 22, 2014 at 11:55 AM, Ronald Green <gr...@gmail.com>wrote:
> I don't know any such function. Searching the web, you'll see many people
> are asking the same question and getting the same answer - sqoop. )
>
>
> On 21 May 2014 19:06, Mandeep Sihag <ma...@googlemail.com> wrote:
>
> > Actually I was interested in directly getting data from database to pig
> > script using storage class.
> >
> >
> > On Wed, May 21, 2014 at 5:07 PM, Ronald Green <green.ronald@gmail.com
> > >wrote:
> >
> > > You can use Apache Sqoop to move data from hdfs to relational databases
> > and
> > > the other way around.
> > >
> > > On 21 May 2014 12:08, Mandeep Sihag <ma...@googlemail.com>
> wrote:
> > >
> > > > Hi,
> > > >
> > > > I want to take input from mysql database, I can see that there is a
> > > > DBStorage class for storing the output on database, but couldn't find
> > the
> > > > implementation for loading data from mysql. Can somebody help.
> > > >
> > > > --
> > > > Mandeep Singh
> > > >
> > >
> >
> >
> >
> > --
> > Mandeep Singh Sihag
> >
> > "Passion is the trigger of success"
> >
>
--
Mandeep Singh Sihag
"Passion is the trigger of success"
Re: DBStorage for loading data from mysql
Posted by Ronald Green <gr...@gmail.com>.
I don't know any such function. Searching the web, you'll see many people
are asking the same question and getting the same answer - sqoop. )
On 21 May 2014 19:06, Mandeep Sihag <ma...@googlemail.com> wrote:
> Actually I was interested in directly getting data from database to pig
> script using storage class.
>
>
> On Wed, May 21, 2014 at 5:07 PM, Ronald Green <green.ronald@gmail.com
> >wrote:
>
> > You can use Apache Sqoop to move data from hdfs to relational databases
> and
> > the other way around.
> >
> > On 21 May 2014 12:08, Mandeep Sihag <ma...@googlemail.com> wrote:
> >
> > > Hi,
> > >
> > > I want to take input from mysql database, I can see that there is a
> > > DBStorage class for storing the output on database, but couldn't find
> the
> > > implementation for loading data from mysql. Can somebody help.
> > >
> > > --
> > > Mandeep Singh
> > >
> >
>
>
>
> --
> Mandeep Singh Sihag
>
> "Passion is the trigger of success"
>
Re: DBStorage for loading data from mysql
Posted by Mandeep Sihag <ma...@googlemail.com>.
Actually I was interested in directly getting data from database to pig
script using storage class.
On Wed, May 21, 2014 at 5:07 PM, Ronald Green <gr...@gmail.com>wrote:
> You can use Apache Sqoop to move data from hdfs to relational databases and
> the other way around.
>
> On 21 May 2014 12:08, Mandeep Sihag <ma...@googlemail.com> wrote:
>
> > Hi,
> >
> > I want to take input from mysql database, I can see that there is a
> > DBStorage class for storing the output on database, but couldn't find the
> > implementation for loading data from mysql. Can somebody help.
> >
> > --
> > Mandeep Singh
> >
>
--
Mandeep Singh Sihag
"Passion is the trigger of success"
Re: DBStorage for loading data from mysql
Posted by Ronald Green <gr...@gmail.com>.
You can use Apache Sqoop to move data from hdfs to relational databases and
the other way around.
On 21 May 2014 12:08, Mandeep Sihag <ma...@googlemail.com> wrote:
> Hi,
>
> I want to take input from mysql database, I can see that there is a
> DBStorage class for storing the output on database, but couldn't find the
> implementation for loading data from mysql. Can somebody help.
>
> --
> Mandeep Singh
>