Error when import a mysql table to hdfs using sqoop

Question

I started learning hadoop and am working on some practice myself, here is an issue when I try to use sqoop to import a mysql table to hdfs:

sqoop import --connect jdbc:mysql://localhost/employees --username=root -P --table=dept_emp --warehouse-dir=dept_emp -where dept_no='d001' --m 1;

The dept_emp has 20k records roughly.

The output is as the following:

2016-09-26 16:42:26,467 INFO [main] ipc.Client: Retrying connect to server: 0.0.0.0/0.0.0.0:8032. Already tried 0 time(s); retry policy is RetryUpToMaximumCountWithFixedSleep(maxRetries=10, sleepTime=1000 MILLISECONDS)

2016-09-26 16:42:27,470 INFO [main] ipc.Client: Retrying connect to server: 0.0.0.0/0.0.0.0:8032. Already tried 1 time(s); retry policy is RetryUpToMaximumCountWithFixedSleep(maxRetries=10, sleepTime=1000 MILLISECONDS)

The "Already tried x time(s)" increased from 0 to 9, and then looped again from 0 to 9, hanging there now.

Can someone shed me some light?

Thank you very much.

KiranM · Accepted Answer · 2016-09-30 16:13:00Z

1

Please correct the syntax:

--where "dept_no='d001'" 
-m 1;

answered Sep 30, 2016 at 16:13

KiranM

1,3241 gold badge11 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

PasLeChoix Over a year ago

Thank you for indicating that.

Collectives™ on Stack Overflow

Error when import a mysql table to hdfs using sqoop

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related