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
68 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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
• 65,850 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 6 days ago in Big Data Hadoop by Yogi
9 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
• 65,850 points
37 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 1 hour ago in Big Data Hadoop by Bhagavath
4 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
• 9,030 points
1,654 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
• 9,030 points
130 views
0 votes
10 answers

hadoop fs -put command?

copy command can be used to copy files ...READ MORE

answered Dec 7, 2018 in Big Data Hadoop by Sujay
8,013 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,260 points
560 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
• 65,850 points
17 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
• 65,850 points
19 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.