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 ...

Get Instant Apache Sqoop now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.