Integration with Hive

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.

Getting ready

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.

How to do it...

1. Connect to the edge1.cyrus.com edge node in the cluster and switch to the user hadoop.

2. We will create an external Hive table and point it to the HBase using the ZooKeeper ensemble.

3. 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'
   

4. Connect either using a hive or beeline client and map by creating a table, as shown next...