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.
signature.asc
Description: Digital signature
