Can Hive work with binary data?

Question

Can Hive work with unstructured data. If we have an image file in the oracle database and we need to run sqoopout to load this image from oracle to another source database and export it also to the hive table. Could you help me on the same how to process this image file in the hive ?????

Answer 1

Your Oracle data is probably stored as a BLOB.
In Hive, it should be stored as BINARY .

Here is a Hortonworks article in which oracle daemon upload sqoop blob into a hive

https://community.hortonworks.com/content/supportkb/49145/how-to-sqoop-import-oracle-blobclob-data-into-hive.html

Hive UDF

https://github.com/apache/hive/blob/master/ql/src/java/org/apache/hadoop/hive/ql/udf/UDFBase64.java