04-26-2018 05:28 AM
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.
05-02-2018 09:44 AM
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.
Create table imageTable(id int , picture binary); Load statement - point to the image location .. could be either managed or external table