Sqoop import error with sqoop job

0 votes

Hi team, I had tried to create a sqoop job, but I am getting errors when I use the following sqoop command. Please run this from your end let me know where the problem was. Thanks

sqoop job --create retaildb_comerica --import --connect jdbc:mysql://mysqldb.edu.cloudlab.com/retail_db --table comerica --username labuser --password edureka --incremental append --check-column customer_id --last-value 12436 --target-dir /user/edureka_227114/Sqoop/inc-comerica -m 1
Jul 9, 2019 in Big Data Hadoop by Esha
2,225 views

1 answer to this question.

0 votes

Please try the below command:

sqoop job -create retaildb_comercia -- import --connect jdbc:mysql://mysqldb.edu.cloudlab.com/retail_db --username labuser --P --table comercia --target-dir sayni_sqoop --check-column customer_id --incremental append --last-value 12436 -m 1

There needs to be a space between -- and import. Also, I am attaching a documentation for sqoop job.

answered Jul 9, 2019 by Rina

Related Questions In Big Data Hadoop

0 votes
1 answer

Sqoop import: import failed error

The problem which you are facing is ...READ MORE

answered Feb 12, 2019 in Big Data Hadoop by Omkar
• 69,210 points
2,734 views
0 votes
1 answer

Getting error while using sqoop import.

You are trying to execute the sqoop ...READ MORE

answered Jul 5, 2019 in Big Data Hadoop by Reshma
1,176 views
0 votes
1 answer
+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
• 11,380 points
10,523 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
• 11,380 points
2,166 views
+2 votes
11 answers

hadoop fs -put command?

Hi, You can create one directory in HDFS ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by nitinrawat895
• 11,380 points
103,826 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,390 points
4,234 views
0 votes
1 answer

Hadoop sqoop import not working. Error: ERROR manager.SqlManager: Error reading from database

In the command, try mentioning the driver ...READ MORE

answered Dec 5, 2018 in Big Data Hadoop by Omkar
• 69,210 points
1,853 views
0 votes
1 answer

Sqoop import gives error: org.apache.hadoop.security.AccessControlException: Permission denied

Seems like you are not passing the ...READ MORE

answered Dec 17, 2018 in Big Data Hadoop by Omkar
• 69,210 points
1,761 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP