BLOB variable

[#1]

Hello,

I am about to create a table in hive and I want to declare a variable which is BLOB and the size 4000. How can I declare it? Is it correct the (image BLOB(4000) ) ?

Thanks a lot

[#2]

BLOB datatype is not available in Hive. You need to use the datatype binary for it. Quoting example from patch which added this feature https://issues.apache.org/jira/secure/attachment/12497862/hive-2380_4.patch

create table ba_test (ba_key binary, ba_val binary);

Hive's Language Manual - https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types

[#3]

@venkatsambath  Thanks a lot for the quick response