hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jean-Daniel Cryans <jdcry...@apache.org>
Subject Re: Migrating Tables with primary key and foreign key from mysql to Hbae
Date Tue, 27 Mar 2012 19:13:40 GMT
Hi,

HBase is not a relational database, it doesn't have foreign keys or
constraints. I'd suggest you familiarize yourself with HBase by
reading the refence manual[1] or buying the book[2].

Regards,

J-D

1. http://hbase.apache.org/book/book.html
2. http://www.amazon.com/dp/1449396100

On Tue, Mar 27, 2012 at 5:25 AM, Neetu Ojha <neetuojha.cdac@gmail.com> wrote:
> Dear all,
>
> I used sqoop tool to migrate the mysql table to hbase but I have not got
> any clearity yet that how the primary keys and foreign keys are preserved
> in Hbase for the tables migrated from mysql database to hbase so that user
> can access the tables from hbase with having the assurance of the data
> integrity and behaviour as it was on Mysql database.
>
> My idea is ti present Hbase as Cloud storage solution and where users can
> migrate there mysql database to Hbase and the behaviour and data integrity
> is entact too.
>
> If any one has experience of the same or idea please share with me.
>
>
> Thanks & Regards
> Neetu

Mime
View raw message