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

Can sqoop display error record

Contributor

 

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?

2 REPLIES 2

Expert Contributor
If you're using Sqoop1, you should be able to use the --verbose option as specified here: http://sqoop.apache.org/docs/1.4.5/SqoopUserGuide.html#_using_generic_and_specific_arguments. Also, be sure to check your MapReduce logs.

Contributor
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.