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-362 Export OraOop failed
Date Tue, 20 Dec 2011 08:21:15 GMT
Hi Antoine,
thank you very much for reporting this issue.

I've actually tried couple of scenarios to confirm whether explicit user mapping will work
with export feature and I did not find a problem. Everything was working for me as expected
both for sequence file and avro data file. I was testing it on MySQL with explicit conversion
int -> string.

Connector OraOop is developed independently on sqoop, so I'm afraid that authors did not add
support for explicit type conversions yet.

Jarcec

On Tue, Dec 20, 2011 at 08:33:53AM +0100, Antoine Pieretti wrote:
> 
> 
> Hi all,
> 
> I have found the patch Sqoop-362 very interesting as we work with Avro
> files.
> The import works well, but when I tryed to export in Oracle with OraOop (I
> think issue is the same without OraOop), the program failed due to a cast
> exception.
> 
> I Have a column in Oracle , type FLOAT, so I have  aded --map-column-java
> MYCOLUMN=Float, nice import in float, but export failed.
> 
> This is due that OraOoop check the column type during the prepare
> statement, Float return Numeric type, so a cast in BigDecimal is applied,
> and failed for a Float.
> 
> I will check if withtout OraOop the process works well or the same cast is
> apply.
> 
> Regards
> 
> Antoine
> Accédez aux meilleurs tarifs Air France, gérez vos réservations et enregistrez-vous
en ligne sur  http://www.airfrance.com  
> Find best Air France fares, manage your reservations and check in online at  http://www.airfrance.com
 Les données et renseignements contenus dans ce message peuvent être de nature confidentielle
et soumis au secret professionnel et sont destinés à l'usage exclusif du destinataire dont
les coordonnées figurent ci-dessus. Si vous recevez cette communication par erreur, nous
vous demandons de ne pas la copier, l'utiliser ou la divulguer. Nous vous prions de notifier
cette erreur à l'expéditeur et d'effacer immédiatement cette communication de votre système.
Société Air France - Société anonyme au capital de 1 901 231 625 euros - RCS Bobigny (France)
420 495 178 - 45, rue de Paris, 95 747 Roissy CDG CEDEX  
> The data and information contained in this message may be confidential and subject to
professional secrecy and are intended for the exclusive use of the recipient at the address
shown above. If you receive this message by mistake, we ask you not to copy, use or disclose
it. Please notify this error to the sender immediately and delete this message from your system.
Société Air France - Limited company with capital of 1,901,231,625 euros - Bobigny register
of companies (France) 420 495 178 - 45, rue de Paris, 95 747 Roissy CDG CEDEX  Pensez à l'environnement
avant d'imprimer ce message.  
> Think of the environment before printing this mail.   

Mime
View raw message