Sqoop import failed while importing mysql table to Hbase

Question

Hi,
While I"m trying to import customers table from mysql to Hbase using Sqoop, receiving error. PFA error details.

[edureka_258791@ip-20-0-41-62 ~]$ sqoop import --connect jdbc:mysql://mysqldb.edu.cloudlab.com/retail_db --username labuser --password edureka --table customers --
hbase-tabel customers123 --hbase-row-key customer_id --column-family cf1 --hbase-create-table -m 1
Warning: /opt/cloudera/parcels/CDH-5.11.1-1.cdh5.11.1.p0.4/bin/../lib/sqoop/../accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
18/11/30 21:10:24 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6-cdh5.11.1
18/11/30 21:10:24 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
18/11/30 21:10:24 ERROR tool.BaseSqoopTool: Error parsing arguments for import:
18/11/30 21:10:24 ERROR tool.BaseSqoopTool: Unrecognized argument: --hbase-tabel
18/11/30 21:10:24 ERROR tool.BaseSqoopTool: Unrecognized argument: customers123
18/11/30 21:10:24 ERROR tool.BaseSqoopTool: Unrecognized argument: --hbase-row-key
18/11/30 21:10:24 ERROR tool.BaseSqoopTool: Unrecognized argument: customer_id
18/11/30 21:10:24 ERROR tool.BaseSqoopTool: Unrecognized argument: --column-family
18/11/30 21:10:24 ERROR tool.BaseSqoopTool: Unrecognized argument: cf1
18/11/30 21:10:24 ERROR tool.BaseSqoopTool: Unrecognized argument: --hbase-create-table
18/11/30 21:10:24 ERROR tool.BaseSqoopTool: Unrecognized argument: -m
18/11/30 21:10:24 ERROR tool.BaseSqoopTool: Unrecognized argument: 1

Answer 1

There is a spelling mistake in your command that is why you are getting the error. You are using hbase-tabel customers123 instead of hbase-table customers123. 

Try this

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