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.
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: