hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jean-Marc Spaggiari <jean-m...@spaggiari.org>
Subject Re: creating tables from mysql to hbase
Date Thu, 20 Feb 2014 02:24:06 GMT
Hi Jignesh,

You might want to ask your questions about Phoenix on the Phoenix mailing
list.

JM


2014-02-19 21:18 GMT-05:00 Jignesh Patel <jigneshmpatel@gmail.com>:

> Assuming this project is used at Salesforce, which has transaction oriented
> db in the past(Or may be today too). How are you handling transactions with
> this?
>
> Just wondering we
>
>
> On Wed, Feb 19, 2014 at 8:51 PM, Jignesh Patel <jigneshmpatel@gmail.com
> >wrote:
>
> > Thank you very much the suggestion. Looks like this is the option I want
> > to go for.
> >
> >
> > -Jignesh
> >
> >
> > On Wed, Feb 19, 2014 at 1:03 AM, James Taylor <jtaylor@salesforce.com
> >wrote:
> >
> >> Hi Jignesh,
> >> Phoenix has support for multi-tenant tables:
> >> http://phoenix.incubator.apache.org/multi-tenancy.html. Also, your
> >> primary
> >> key constraint would transfer over as-is, since Phoenix supports
> composite
> >> row keys. Essentially your pk constraint values get concatenated
> together
> >> to form your row key in HBase. We do not support unique constraints yet,
> >> but we do support secondary indexing:
> >> http://phoenix.incubator.apache.org/secondary_indexing.html
> >>
> >> HTH. Thanks,
> >>
> >> James
> >>
> >>
> >> On Tue, Feb 18, 2014 at 6:06 PM, Jean-Marc Spaggiari <
> >> jean-marc@spaggiari.org> wrote:
> >>
> >> > You might want to take a look at Phoenix
> >> > http://phoenix.incubator.apache.org/
> >> >
> >> > JM
> >> >
> >> >
> >> > 2014-02-18 19:29 GMT-05:00 Jignesh Patel <jigneshmpatel@gmail.com>:
> >> >
> >> > > Jean,
> >> > >
> >> > > We have a product which is working on mysql and we are trying to
> move
> >> it
> >> > on
> >> > > HBase to create multi-tenant database.
> >> > > I agree with you that because of nosql nature of database, we should
> >> > > denormalize the mysql database. However, was thinking of making
> quick
> >> > > progress by first creating dirty structure of existing database in
> >> > > hbase(from mysql) and than optimizing/modifying in nosql way.
> >> > >
> >> > >
> >> > >
> >> > > On Tue, Feb 18, 2014 at 4:11 PM, Jean-Marc Spaggiari <
> >> > > jean-marc@spaggiari.org> wrote:
> >> > >
> >> > > > Moving the discussion to the user mailing list.
> >> > > >
> >> > > > Hi Jignesh,
> >> > > >
> >> > > > You can not really map mysql tables to HBase. You need to rethink
> >> your
> >> > > > schema when moving to HBase. Like in MySQL, a key can be on
> multiple
> >> > > > columns. In HBase, it's they key itself. etc.
> >> > > >
> >> > > > What are you trying to achieve?
> >> > > >
> >> > > > JM
> >> > > >
> >> > > >
> >> > > > 2014-02-18 15:19 GMT-05:00 Jignesh Patel <jigneshmpatel@gmail.com
> >:
> >> > > >
> >> > > > > Has anybody used for creating tables from msyql to Hbase
through
> >> > cloud
> >> > > > > graph?
> >> > > > >
> >> > > >
> >> > >
> >> >
> >>
> >
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message