Reply
Contributor
Posts: 40
Registered: ‎06-16-2014

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?

Cloudera Employee abe
Cloudera Employee
Posts: 109
Registered: ‎08-08-2013

Re: Can sqoop display error record

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
Posts: 40
Registered: ‎06-16-2014

Re: Can sqoop display error record

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.
Announcements
New solutions