New Contributor
Posts: 2
Registered: ‎04-26-2018

How to store PDF/images in Hive table?


In my use case, I need to store one or more documents(pdf or images) in hive table corresponding to id.

I have tried to find a way but could not find a precise solution.


Can somebody please let me know what will be the DDL and DML statements for the above purpose?


Many thanks in advance.

Posts: 710
Registered: ‎05-16-2016

Re: How to store PDF/images in Hive table?

if you just want to load the image in the hive table not process fruther  use binary data type , but to view or process you need to have like some java code to convert that into binary data before you load in to hive table. 


Something like 

Create table imageTable(id int , picture binary);
Load statement - point to the image location ..
could be either managed or external table