May 2017
Beginner to intermediate
596 pages
15h 2m
English
Content preview from Data Lake for Enterprises
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Sqoop Export
Similar to the Sqoop import function, Sqoop also can export data from HDFS to a relational database. The precondition, however, is that the table must be already existing in the target database:
sqoop export (generic-args) (export-args)sqoop export --connect jdbc:postgresql://<DB_SERVER_ADDRESS>/<DB_NAME>?schema=<SCHEMA> --table <TABLE_NAME> --m 1 --username <DB_USER_NAME> --password <DB_PASSWORD> --export-dir <HDFS_SOURCE_PATH>
Here <HDFS_SOURCE_PATH> is the Hadoop filesystem path as a source that would be exported to a target database:
Figure 19: Export to RDBMS from HDFS using Sqoop Export