Let's now discuss the different tables available in our MySQL database that we will be exporting to our HBase database. We will be simulating an employee database, which will have information related to their personal information and the details of their salaries. In order to simulate a full scenario, we will also be installing MySQL database in our computer so that we can perform all of the actions from end to end in practical terms. So, let's start with the installation of a MySQL server.
Data analysis
Installing MySQL
Installing the MySQL database is pretty straightforward in Ubuntu. Just execute the following command to install it:
$ sudo apt-get install mysql-server
It will first prompt you to confirm to start...