In this recipe, we look at how we can integrate Hive with HBase and use Hive to perform all the data operations.
You will have realized from the previous recipe that it gets cumbersome to perform queries using just the native HBase commands.
Before going through the recipe, you must have completed the Hive metastore using MySQL recipe in Chapter 7, Data Ingestion and Workflow, and the Setting up multi-node HBase cluster recipe.
Connect to the
edge1.cyrus.com
edge node in the cluster and switch to the userhadoop
.We will create an external Hive table and point it to the HBase using the ZooKeeper ensemble.
Create a table in HBase if it is not there already, as shown next:
hbase> create 'hivetable', 'ratings' put 'hivetable', 'row1', 'ratings:userid', 'user1' put 'hivetable', 'row1', 'ratings:bookid', 'book1' put 'hivetable', 'row1', 'ratings:rating', '1'
Connect either using a hive or beeline client and map by creating a table, as shown next...