CODEWITHSUNDEEP
hadoopmemoryhivehbasebigdata
Jnmgr
Jnmgr

Reputation: 179

Using Hbase into Hive, possible?

I have data stored in Hive, I want access to them from Hbase getting fast perfomance. Is this possible? Is there another framework which can access to hive using memory? Just no Spark.

Upvotes: 0

Views: 45

Answers (1)

madhu
madhu

Reputation: 1170

Yes, there is storage handler called 

org.apache.hadoop.hive.hbase.HBaseStorageHandler

through which you will be able to access hive data through Hbase.Create a table in HBase and map that table to a hive table using the below syntax. After that load the hive table and then access it from hbase.

CREATE TABLE tablename(.......)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ("hbase.columns.mapping" = "......")
TBLPROPERTIED ("hbase.table.name" = "........");

Upvotes: 1

Related Questions