Clever Geek Handbook

Handling a blob in a hive

I want to store and retrieve a blob in a hive. Is it possible to store a blob in a hive? If this is not supported, what alternatives can I use? Blob can also be inside a DB relationship. I have done some research but did not find a suitable solution.

+3


source to share


2 answers


I think it is possible to store blob in Hive. I imported LOBs from Oracle DB into Hive throught Sqoop and all I had to do was distinguish the LOBs into a string:

 sqoop import --map-column-java $LOB=String


You can find more details about LOB in Sqoop here .

Hope it helps

0


source


As of Hive 0.8.0, you can use the binary data type in the hive. This is a perfect fit for blobs. I can't find the maximum length of a binary, but I know it's 2GB for a String, so this is my best guess for binaries.



0


source






More articles:


All Articles