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, 2019 in Big Data Hadoop by Sharan
523 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, 2019 by Omkar
• 69,040 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, 2019 in Big Data Hadoop by Yogi
133 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, 2019 in Big Data Hadoop by Omkar
• 69,040 points
701 views
0 votes
1 answer

How to fetch more data from database while using Sqoop import?

Hey. You guessed it right. The max ...READ MORE

answered May 15, 2019 in Big Data Hadoop by Gani
671 views
0 votes
1 answer

Sqoop error while trying to connect to MySql

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

answered May 22, 2019 in Big Data Hadoop by Bhagavath
447 views
+1 vote
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,920 points
5,484 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,920 points
808 views
+1 vote
11 answers

hadoop fs -put command?

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

answered Dec 7, 2018 in Big Data Hadoop by Aditya
33,988 views
–1 vote
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,310 points
2,068 views
0 votes
1 answer

Sqoop getting error while connecting to MySQL

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

answered Feb 7, 2019 in Big Data Hadoop by Omkar
• 69,040 points
150 views
0 votes
1 answer

Sqoop error while importing data from MySql

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

answered Feb 11, 2019 in Big Data Hadoop by Omkar
• 69,040 points
214 views