Book Image

HBase High Performance Cookbook

By : Ruchir Choudhry
Book Image

HBase High Performance Cookbook

By: Ruchir Choudhry

Overview of this book

Apache HBase is a non-relational NoSQL database management system that runs on top of HDFS. It is an open source, disturbed, versioned, column-oriented store and is written in Java to provide random real-time access to big Data. We’ll start off by ensuring you have a solid understanding the basics of HBase, followed by giving you a thorough explanation of architecting a HBase cluster as per our project specifications. Next, we will explore the scalable structure of tables and we will be able to communicate with the HBase client. After this, we’ll show you the intricacies of MapReduce and the art of performance tuning with HBase. Following this, we’ll explain the concepts pertaining to scaling with HBase. Finally, you will get an understanding of how to integrate HBase with other tools such as ElasticSearch. By the end of this book, you will have learned enough to exploit HBase for boost system performance.
Table of Contents (19 chapters)
HBase High Performance Cookbook
Credits
About the Author
About the Reviewer
www.PacktPub.com
Customer Feedback
Preface
7
Large-Scale MapReduce
Index

Accessing HBase data with hive


The Hive architecture is by design scalable and can easily scale for hundreds or millions of users; clubbing it with Hbase makes the right integration choice. It also make Hbase interoperate with Hive; a simple Hbase table can be accessed from Hive as if it was a Hive table itself.

A single hive query can perform joins, unions, and Cartesian joins by aggregating a combination of Hbase and Hive tables.

Similarly, the inserts can also be applied between Hbase and native Hive tables.

In a nutshell, we can solve the following usecase:

  • Incremental refresh problems by keeping a near real-time replica of MySql data in Hbase

  • We can pick and chose when to use Hbase and when to use native Hive tables as hive tables are much faster to read and write.

How to do it …

Connecting Hive to Hbase:

  1. I am assuming your EMR cluster is still running and you are able to connect using putty or directly ssh to the cluster.

  2. Write hive in the command shell and you will be connected to the hive...