sqoop export with updateonly mode is getting timeout and failing.
I have executed the following command:
sqoop export
–connect jdbc:mysql://172.31.20.247/retail_db
–username sqoopuser \
-P
–table orders_csm
–export-dir retail_db/orders
–update-key order_id
–update-mode updateonly
Here is output and failing after timeout:
18/10/05 01:49:17 INFO mapreduce.Job: Job job_1537636876515_1990 running in uber mode : false
18/10/05 01:49:17 INFO mapreduce.Job: map 0% reduce 0%
18/10/05 01:49:28 INFO mapreduce.Job: map 1% reduce 0%
18/10/05 01:49:40 INFO mapreduce.Job: map 2% reduce 0%
18/10/05 01:50:56 INFO mapreduce.Job: map 3% reduce 0%
18/10/05 01:52:06 INFO mapreduce.Job: map 4% reduce 0%
18/10/05 01:53:22 INFO mapreduce.Job: map 5% reduce 0%
18/10/05 01:54:32 INFO mapreduce.Job: map 6% reduce 0%
18/10/05 01:55:48 INFO mapreduce.Job: map 7% reduce 0%
18/10/05 01:56:58 INFO mapreduce.Job: map 8% reduce 0%
18/10/05 01:58:14 INFO mapreduce.Job: map 9% reduce 0%
18/10/05 01:59:21 INFO mapreduce.Job: map 10% reduce 0%
18/10/05 02:00:37 INFO mapreduce.Job: map 11% reduce 0%
I am facing the same issue, if I execute the command without --update-mode.
The same issue is observed in the Cloudera Sandbox.