Does Phoenix on Hbase supports transactional behaviour

[Mich Talebzadeh <mi...@gmail.com>]

Hi,

As far as I can ascertain and I have put this question to Hbase forum,
Hbase itself does not provide transactional support.

However, I have been told that Transactions (beta) in Apache Phoenix may
support this.

Having said that I am sceptical whether Hbase with Phoenix can do what an
RDBMS does by supporting a batch of transactions with commit/rollback etc.
Has anyone had the experience of using Phoenix on Hbase for transactional
compliance please?


Thanks


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.

Re: Does Phoenix on Hbase supports transactional behaviour

[ashish tapdiya <as...@gmail.com>]

Hello Mich,

Phoenix provides transaction support through integration with Apache
Tephra. The transaction support implementation is MVCC based with snapshot
isolation. We can batch statements together in a transaction, can commit it
and rollback if commit fails just like in a RDBMS. Below is the web page
that describes basic usage,

https://phoenix.apache.org/transactions.html

Thanks,
Ashish

On Mon, Nov 28, 2016 at 4:58 PM, Mich Talebzadeh <mi...@gmail.com>
wrote:

> Hi,
>
> As far as I can ascertain and I have put this question to Hbase forum,
> Hbase itself does not provide transactional support.
>
> However, I have been told that Transactions (beta) in Apache Phoenix may
> support this.
>
> Having said that I am sceptical whether Hbase with Phoenix can do what an
> RDBMS does by supporting a batch of transactions with commit/rollback etc.
> Has anyone had the experience of using Phoenix on Hbase for transactional
> compliance please?
>
>
> Thanks
>
>
> 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.
>
>
>