Hi Antoine, The following would be helpful in figuring out what could be causing the failed job:
What Sqoop, OraOop, and Hadoop versions are you running? Please run Sqoop job with --verbose flag and then attach console log. Also, provide a representative input data set that triggers this problem. Regards, Kate On Tue, Dec 6, 2011 at 12:15 AM, Antoine Pieretti < [email protected]> wrote: > Hi folks, > > i am a newbie within Sqoop and Avro. > > I try to manipulate data from an Oracle Database, import, and export Avro > files. > > The import works well, the export (INSERT) also, but when i am trying to > Update data from an Avro file to the DB the job failed. > > Here my command line : export --connect jdbc:oracle:thin:@qxxxxxxx--username > xxxxxxxxxxxxxxxxx_O --password xxxxxxxxxxx_O --table MY_TABLE > --verbose --export-dir D:\\tmp\extraction\Rep --update-key My_COLUMN_KEY. > > The job calls the TextExportMapper (not the AvropExportMapper), and try to > parse the file, wich contains the Avro schemas and parse it as a data line. > > Is it a common issue ? > > Thanks for your help > > Antoine PIERETTI > > > 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. > >
