https://community.cloudera.com/t5/Support-Questions/How-can-I-convert-the-BLOB-data-to-the-actual-file-when/m-p/230158#M192008 <P>Hi <A rel="user" href="https://community.cloudera.com/users/51243/jyothireddy119.html" nodeid="51243">@jyothi k</A>,</P><P>While I was doing a migration from RDBMS to Hive I did come across the same scenario, that BLOB, CLOB data.</P><P>I did approch in a manner that covert the BLOB and CLOB data using bese64 encoding (convert any kind of binary data into readable text format) store in Hive.</P><PRE>select UTL_ENCODE.BASE64_ENCODE(blob_column) from oracle_tbl; -- from Orcale</PRE><P>This gives the base64 encoding string, so that you can store this as String in Hive/hdfs, which fed to Sqoop as string.</P><P>on the other hand to convert back to BLOB you can use hive unbase64 (). </P><P>or the java Base64 package (can be used in either native java Apps or Spark etc etc..)</P><P>example :</P><PRE>select unbase64(converted_blob_column) from hive_table;</PRE><P>for native apps you may refer the java docs for Base64 conversion <A target="_blank" href="https://docs.oracle.com/javase/8/docs/api/java/util/Base64.html ">here </A></P><P>Hope this helps !!</P> Wed, 20 Dec 2017 07:16:31 GMT bkosaraju 2017-12-20T07:16:31Z