I found the old thread that is exactly similar to the issue I am having . https://community.cloudera.com/t5/Support-Questions/SQOOP-import-of-quot-image-quot-data-type-into-hive/m-p/376825#M243019 column data type in source [sql server] : imagecolumn value in source : 0xFFffDeDJBF.......dDf.      --> ( A hexadecimal value ) column data type in hive: string  column value in hive: FFffDeDJBF.......dDf (0x is not retained) Also I have tried binary data type in hive. yet the value would not match with what oracle has.  Is there a data type hive table can handle and retain the  'Image' datatype orginal value in SQL source while sqoop importing into the hive table ?    ... View more