sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jarek Jarcec Cecho <jar...@apache.org>
Subject Re: sqoop report on invalid rows
Date Fri, 03 May 2013 05:40:42 GMT
Hi Thuy,
Sqoop currently requires you to have clean data set without any corruptions. I think that
you can run custom mapreduce/pig job to clean the data up prior exporting them with Sqoop.

Jarcec

On Tue, Apr 30, 2013 at 09:35:59PM -0700, Thuy Nguyen wrote:
> Hi all,
> 
> I would like to export some data from hdfs to mysql, and certain values are
> not in the format expected by mysql type, e.g. '1234 ' instead of '1234',
> then sqoop will fail.
> 
> Is there a way to export valid data rows into a table, and report on
> invalid data/rows?
> 
> Thanks,
> Thuy

Mime
View raw message