Support Questions
Find answers, ask questions, and share your expertise

Can sqoop display error record



Hi, when I use sqoop to export data to Oracle, some records may cause error. However, I don't know which record is the cause.


Is there any way sqoop can directly display such records?


Expert Contributor
If you're using Sqoop1, you should be able to use the --verbose option as specified here: Also, be sure to check your MapReduce logs.

I have already tried --verbose, however, it didn't work.

What I need is to show the content of the records that cause error. For example, if it cause "value too large for column" error when inserting, I want to know what is the value.