Migrating data from MySQL to HBase using Sqoop
In this recipe, we will cover how to migrate data from MySQL to HBase. This could be a very common use case in any organization that has been using RDMS and wants to move to HBase.
An important thing to understand here is that the intent of migration is not a replacement for the traditional RDBMS system, but to complement it.
To do this operation we will be using Sqoop to import data from RDBMS to Hadoop. The destination could be the HDFS filesystem, Hive, or HBase.
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. Make sure the services for HBase, YARN, and HDFS are running as shown in the following screenshot:
How to do it...
- Connect to the
edge1.cyrus.comedge node and switch to the userhadoop. - Although you can do these steps on any node, all clients are installed on the edge nodes.
- Firstly, we...
