https://community.cloudera.com/t5/Support-Questions/sqoop-import-of-BLOB-columns-from-oracle-database/m-p/286851#M212700 <P><a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/72796">@pavan_kumar</a>&nbsp;</P><P>&nbsp;</P><P><STRONG>I tried with --map-column-java column_name=binary /Binary</STRONG></P><P><U>Below is the errors that i get :&nbsp;</U></P><P>20/01/05 10:04:58 ERROR tool.ImportTool: Import failed: No ResultSet method for Java type binary</P><P>&nbsp;</P><P>20/01/05 10:04:07 ERROR tool.ImportTool: Import failed: No ResultSet method for Java type Binary</P><P>&nbsp;</P><P><STRONG>i tried map-column-hive column_name=binary</STRONG></P><P>The sqoop import was success but when i query the table in impala it shows the below error</P><P><FONT color="#FF0000"><SPAN>AnalysisException: Unsupported type 'BINARY' in Table</SPAN></FONT></P><P>All other columns are accessible but the blob one is corrupted and hence unable to query</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Sun, 05 Jan 2020 08:43:39 GMT sow 2020-01-05T08:43:39Z