AnsweredAssumed Answered

Sqoop1 unable to import BLOB (Images) from Oracle to Hive

Question asked by irfanzaidi on Dec 29, 2017
Latest reply on May 22, 2018 by miteshgala92

Hi Guys, 

I am trying to import table that has BLOB with images from Oracle into Hive. The import get succeed but the binary data does not come correctly. Please note that BLOB_CONTENTS field in Hive table is Binary data type. I will appreciate your help.


Following is my aqoop command:

sqoop import \
--connect jdbc:oracle:thin:@server:1521:sid \
--username username -P \
--table table_name \
--split-by ID \
--fields-terminated-by "\001" \
--map-column-hive BLOB_CONTENTS=binary \
--hive-import --hive-database DB --hive-overwrite --hive-table Hive_Table