Support Questions
Find answers, ask questions, and share your expertise

BLOB variable

BLOB variable

Explorer

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 REPLIES 2

Re: BLOB variable

Expert Contributor

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

Re: BLOB variable

Explorer

@venkatsambath  Thanks a lot for the quick response