Sqoop import failed while importing mysql table to Hbase

0 votes
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
Feb 6 in Big Data Hadoop by Sharan
143 views

1 answer to this question.

0 votes

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
answered Feb 6 by Omkar
• 67,290 points

Related Questions In Big Data Hadoop

0 votes
1 answer

How to decrease load on HBase while importing Sqoop?

Sqoop by default serializes all the input ...READ MORE

answered May 16 in Big Data Hadoop by Yogi
30 views
0 votes
1 answer

Sqoop transfer file from MySql to HBase

Sqoop doesn’t permit you to import, all ...READ MORE

answered Feb 11 in Big Data Hadoop by Omkar
• 67,290 points
90 views
0 votes
1 answer
0 votes
1 answer

Sqoop error while trying to connect to MySql

Please use the below command to solve ...READ MORE

answered May 22 in Big Data Hadoop by Bhagavath
40 views
0 votes
1 answer

Hadoop Mapreduce word count Program

Firstly you need to understand the concept ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 10,510 points
2,407 views
0 votes
1 answer

hadoop.mapred vs hadoop.mapreduce?

org.apache.hadoop.mapred is the Old API  org.apache.hadoop.mapreduce is the ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 10,510 points
246 views
0 votes
10 answers

hadoop fs -put command?

put syntax: put <localSrc> <dest> copy syntax: copyFr ...READ MORE

answered Dec 7, 2018 in Big Data Hadoop by Aditya
12,237 views
0 votes
1 answer

Hadoop dfs -ls command?

In your case there is no difference ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by kurt_cobain
• 9,240 points
898 views
0 votes
1 answer

Sqoop getting error while connecting to MySQL

Have you set a password for MySQL? ...READ MORE

answered Feb 7 in Big Data Hadoop by Omkar
• 67,290 points
42 views
0 votes
1 answer

Sqoop error while importing data from MySql

As the error states, the target directory ...READ MORE

answered Feb 11 in Big Data Hadoop by Omkar
• 67,290 points
38 views