- last edited on
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
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
@venkatsambath Thanks a lot for the quick response