O'Reilly logo

Instant Apache Sqoop by Ankit Jain

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The exporting process (Intermediate)

As mentioned in the Working with the import process recipe, Sqoop has two important features: importing and exporting data. So far, we have only worked on the import feature. This recipe will give us an overview of the Sqoop export process.

Exporting a process means moving the HDFS data back to the RDBMS table. The output table must exist in RDBMS before running the export job. Sqoop reads the records from the delimited text file one-by-one, translates it into the RDBMS INSERT command, and then inserts it into the output table. If the output table contains a primary key, the value of the primary key column in the input file must be unique and not null; otherwise, the export process will stop due to the violation ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required