hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mich Talebzadeh <mich.talebza...@gmail.com>
Subject Hive metadata on Hbase
Date Sun, 23 Oct 2016 22:46:51 GMT
A while back there was some notes on having Hive metastore on Hbase as
opposed to conventional RDBMSs

I am currently involved with some hefty work with Hbase and Phoenix for
batch ingestion of trade data. As long as you define your Hbase table
through Phoenix and with secondary Phoenix indexes on Hbase, the speed is
impressive.

I am not sure how much having Hbase as Hive metastore is going to add to
Hive performance. We use Oracle 12c as Hive metastore and the Hive
database/schema is built on solid state disks. Never had any issues with
lock and concurrency.

Therefore I am not sure what one is going to gain by having Hbase as the
Hive metastore? I trust that we can still use our existing schemas on
Oracle.

HTH



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.

Mime
View raw message