Re: Migrating Tables with primary key and foreign key from mysql to Hbae

2012-03-27 Thread Rohit Kelkar
Neetu, In my opinion it is a bad idea to "copy paste" a normalized schema from an RDBMS to a nosql database like hbase. Hbase encourages denormalization. Hbase does not support indexing out of the box like mysql/postgres/etc. So your retrieval time would be affected as the data size grows. For inde

Re: Migrating Tables with primary key and foreign key from mysql to Hbae

2012-03-27 Thread Neetu Ojha
Hi Jean, Thanks A lot for reply, I got your point about HBASE , let me give a little clear picture of what I am desiring from HBase , If any body is willing to migrate ones application on Hadoop and at teh same time migrate Mysql database to Hbase to get the advantage of the Hbase in that case i

Re: Migrating Tables with primary key and foreign key from mysql to Hbae

2012-03-27 Thread Jean-Daniel Cryans
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