Re: creating tables from mysql to hbase

2014-02-19 Thread Jean-Marc Spaggiari
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 : > 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

Re: creating tables from mysql to hbase

2014-02-19 Thread Jignesh Patel
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 wrote: > Thank you very much the suggestion. Looks like this is the opti

Re: creating tables from mysql to hbase

2014-02-19 Thread Jignesh Patel
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 wrote: > Hi Jignesh, > Phoenix has support for multi-tenant tables: > http://phoenix.incubator.apache.org/multi-tenancy.html. Also, your primary > key cons

Re: creating tables from mysql to hbase

2014-02-18 Thread James Taylor
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 k

Re: creating tables from mysql to hbase

2014-02-18 Thread Jean-Marc Spaggiari
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 : > 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 n

Re: creating tables from mysql to hbase

2014-02-18 Thread Jignesh Patel
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 struc

Re: creating tables from mysql to hbase

2014-02-18 Thread Jean-Marc Spaggiari
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 1