The following command will import data from MySQL into Hbase columnar database for a few specified columns from a certain table.
Connect to MySQL and verify that the source table is present. Make a note of the names of the table and columns.
To move data from MySQL to Hbase, run the following command in the Hadoop terminal.
sqoop import \
–connect jdbc:mysql://localhost/dbTest \
–username root
–password root
–table tbEmployee \
–columns “EmpNo, EName” \
–hbase-table Employee \
–column-family EmpName \
–hbase-row-key EmpNo \
-m 1;
Once the transfer is completed, connect to Hbase and use the following command to check if the data is populated into the table.
scan ‘Employee’;
Hope you find this article helpful.
Please subscribe for more interesting updates.
Big Data and SQL 