Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Sqoop fetches less data

avatar
Explorer

Hi,

 

I run a sqoop import in order to fetch data from a table in sql server. Inside the sqoop I have a query which fetches every 6 mins data from 2 hours before until now. The weird thing is that sqoop doesnt fetch all the data. It is somehow random how many data it fetches. My sqoop command is the below. For example in this 2 hours scanning I fetched a record 28 times. 19 times all the rows were align with the  sql server but 9 they were half

 

 sqoop import 
--connect 'jdbc:sqlserver\
--username  \
--password-alias \
--num-mappers 10 \
--split-by an_int \
--fields-terminated-by '|' \
--query "select * from table where timestamp > '${offset}' and \$CONDITIONS" \
--delete-target-dir \
--target-dir 

 

The amount of the data for 2 hours is ~800k

1 REPLY 1

avatar
Expert Contributor

Hi @drgenious 

Please share us the Sqoop console logs with --verbose logs and the yarn application logs for review.