question sqoop import of BLOB columns from oracle database in Support Questions

question sqoop import of BLOB columns from oracle database in Support Questions https://community.cloudera.com/t5/Support-Questions/sqoop-import-of-BLOB-columns-from-oracle-database/m-p/286668#M212574 I have to import table from oracle that contains both blob and clob   --map-column-java CLOB_column=String works fine --map-column-java BLOB_column=String throws error   How do we import blob data type columns from oracle using sqoop ?   Query used:   sqoop import --connect 'jdbc:oracle:thin:@serveri_ip:port/database' --username <> -password <> --query "SELECT *  FROM table_name WHERE \$CONDITIONS" --map-column-java CMID=Integer,DATAPROP=String --as-parquetfile --delete-target-dir --target-dir /user/test/ --m 1   DATAPROP --> is the BLOB column   Tue, 31 Dec 2019 14:49:50 GMT sow 2019-12-31T14:49:50Z