Sqoop transfer file from MySql to HBase

Question

sqoop import --connect jdbc:mysql://mysqldb.edu.cloudlab.com/retail_db --username labuser --password edureka --table customers --hbase-table hbaseimport --hbase-row-key customer_id,customer_city --column-family cf1 --hbase-create-table -m 1;

This command will transfer a file from mysql to hbase for one column family. What if I have more than one column family?

Answer 1

Sqoop doesn’t permit you to import, all at once, a relational table directly into an HBase table having multiple column families. To work around this limitation, you create the HBase table first and then execute two Sqoop import operations to finish the task.

Please refer to the below link for more details:

https://www.dummies.com/programming/big-data/hadoop/importing-data-into-hbase-with-sqoop/