@Shelton    could you please repost the solution ?? I am facing similar issue.   separate thread for the same created  https://community.cloudera.com/t5/Support-Questions/sqoop-import-of-BLOB-columns-from-oracle-database/m-p/286761#M212633   Thanks in advance ... View more

Seems BASE64_ENCODE has limitation on byte size, I got below error while trying import with BLOB data size ~127KB. java.sql.SQLException: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 129892, maximum: 2000) ... View more