Support Questions
Find answers, ask questions, and share your expertise

Sqoop Import Oracle Blob Data to HDFS

Highlighted

Sqoop Import Oracle Blob Data to HDFS

Any idea on how to import Oracle Blob data into HDFS using Sqoop Import

Sundar Gampa
2 REPLIES 2

Re: Sqoop Import Oracle Blob Data to HDFS

Explorer
@Sundar Gampa

You can find your answers in this article. Let me know if you encounter any issues.

https://community.hortonworks.com/content/supportkb/49145/how-to-sqoop-import-oracle-blobclob-data-i...

Highlighted

Re: Sqoop Import Oracle Blob Data to HDFS

Explorer

For HDFS, you can just mention the --target-dir option with your hdfs target directory. Sqoop import command will be as follows:

sqoop import --connect {connect-info} --table {table_name} --target-dir {hdfs_import_dir} -m {NUM_MAPPERS}