hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dhruba Borthakur <dhr...@gmail.com>
Subject Re: Question about HBase for OLTP
Date Mon, 09 Jan 2012 18:55:45 GMT
> I know HBase is designed for OLAP, query intensive type of applications.

That is not entirely true. HBase is a pure transaction system and does OLTP
workloads for us. We probably more than 2 millions ops/sec for one of our
application, details here:


On Mon, Jan 9, 2012 at 9:25 AM, fullysane <fullysane@msn.com> wrote:

> Hi
> I know HBase is designed for OLAP, query intensive type of applications.
> But
> I like the flexibility feature of its column-base architecture which allows
> me having no need to predefine every column of a table and I can
> dynamically
> add new column with value in my OLTP application code and capture its meta
> data information.
> My question is basically about if we can use HBase for OLTP application
> database. I know Hbase works well with Inserting column data of a row key
> and set new version for the new piece of the data, and not so well for
> updating and deleting existing piece of data. However, if I turn OLTP
> update
> and delete operations into all insertion of new version of colum data as I
> described below:
> For OLTP data update, if I set my table column family’s versioning to 1 and
> always do insert (put) when there is need to update an existing data row
> columns, and let Hbase to handle the delete of the old versions through DB
> garbage collection.
> For OLTP data delete, I can use inserting new version on a flag field to
> “deleted”, which is a logical delete, and have some batch job to clean up
> all logically deleted rows later.
> Will the above scenario work for using HBase for an OLTP application? Any
> flaws on doing it?
> Can some one share the experiences of using HBase for OLTP applications?
> Thanks,
> --
> View this message in context:
> http://old.nabble.com/Question-about-HBase-for-OLTP-tp33107782p33107782.html
> Sent from the HBase User mailing list archive at Nabble.com.

Subscribe to my posts at http://www.facebook.com/dhruba

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