You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hbase.apache.org by Vishal Kapoor <vi...@gmail.com> on 2011/06/23 20:32:21 UTC

export data from HBase to mysql

Looking for tools to help export Data from HBase to MySQL,
will need some transformations before inserting.

thanks,
Vishal

Re: export data from HBase to mysql

Posted by Bill Graham <bi...@gmail.com>.

AFAIK, sqoop can only write to HBase at this point.

We use Pig's HBaseStorage class to read from HBase and transform data for
import into other system, which has worked well for us.

On Thu, Jun 23, 2011 at 11:38 AM, Vishal Kapoor
<vi...@gmail.com>wrote:

> thought it was only SQL-to-Hadoop
> can it also dump from HBase to SQL?
> how do I take care of transformations?
>
> On Thu, Jun 23, 2011 at 2:33 PM, Ted Yu <yu...@gmail.com> wrote:
>
> > Have you checked out sqoop ?
> >
> > On Thu, Jun 23, 2011 at 11:32 AM, Vishal Kapoor
> > <vi...@gmail.com>wrote:
> >
> > > Looking for tools to help export Data from HBase to MySQL,
> > > will need some transformations before inserting.
> > >
> > > thanks,
> > > Vishal
> > >
> >
>

Re: export data from HBase to mysql

Posted by Vishal Kapoor <vi...@gmail.com>.

thought it was only SQL-to-Hadoop
can it also dump from HBase to SQL?
how do I take care of transformations?

On Thu, Jun 23, 2011 at 2:33 PM, Ted Yu <yu...@gmail.com> wrote:

> Have you checked out sqoop ?
>
> On Thu, Jun 23, 2011 at 11:32 AM, Vishal Kapoor
> <vi...@gmail.com>wrote:
>
> > Looking for tools to help export Data from HBase to MySQL,
> > will need some transformations before inserting.
> >
> > thanks,
> > Vishal
> >
>

Re: export data from HBase to mysql

Posted by Ted Yu <yu...@gmail.com>.

Have you checked out sqoop ?

On Thu, Jun 23, 2011 at 11:32 AM, Vishal Kapoor
<vi...@gmail.com>wrote:

> Looking for tools to help export Data from HBase to MySQL,
> will need some transformations before inserting.
>
> thanks,
> Vishal
>