hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mich Talebzadeh <mich.talebza...@gmail.com>
Subject Re: Using Hbase as a transactional table
Date Wed, 23 Nov 2016 17:19:06 GMT
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 <datagwal@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.talebzadeh@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.
>
>

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