Thanks all. As I understand Hbase does not support ACIC compliant transactions over multiple rows or across tables?
So this is not supported 1. Hbase can support multi-rows transactions if the rows are on the same table and in the same RegionServer? 2. Hbase does not support multi-rows transactions if the rows are in different tables but happen to be in the same RegionServer? 3. If I migrated RDBMS transactional tables to the same Hbase table (big if) with different column familities will that work? Design considerations 1. If I have 4 big tables in RDBMS, some having in excess of 200 columns (I know this is a joke), can they all go one-to-one to Hbase tables. Can some of these RDBMS tables put into one Hbase schema with different column families. 2. then another question. If I use hive tables on these hbase tables with large number of family columns, will it work ok? thanks 1. Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* http://talebzadehmich.wordpress.com *Disclaimer:* Use it at your own risk. Any and all responsibility for any loss, damage or destruction of data or any other property which may arise from relying on this email's technical content is explicitly disclaimed. The author will in no case be liable for any monetary damages arising from such loss, damage or destruction. On 23 November 2016 at 16:43, Denise Rogers <datag...@aol.com> wrote: > I would recommend MariaDB. HBase is not ACID compliant. MariaDB is. > > Regards, > Denise > > > Sent from mi iPad > > > On Nov 23, 2016, at 11:27 AM, Mich Talebzadeh <mich.talebza...@gmail.com> > wrote: > > > > Hi, > > > > I need to explore if anyone has used Hbase as a transactional table to do > > the processing that historically one has done with RDBMSs. > > > > A simple question dealing with a transaction as a unit of work (all or > > nothing). In that case if any part of statement in batch transaction > fails, > > that transaction will be rolled back in its entirety. > > > > Now how does Hbase can handle this? Specifically at the theoretical level > > if a standard transactional processing was migrated from RDBMS to Hbase > > tables, will that work. > > > > Has anyone built successful transaction processing in Hbase? > > > > Thanks > > > > > > Dr Mich Talebzadeh > > > > > > > > LinkedIn * https://www.linkedin.com/profile/view?id= > AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw > > <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCd > OABUrV8Pw>* > > > > > > > > http://talebzadehmich.wordpress.com > > > > > > *Disclaimer:* Use it at your own risk. Any and all responsibility for any > > loss, damage or destruction of data or any other property which may arise > > from relying on this email's technical content is explicitly disclaimed. > > The author will in no case be liable for any monetary damages arising > from > > such loss, damage or destruction. > >