need to provide the following syntax :
insert into tlobh3 values (1, filetolob('hdfs:///mydata/c1.txt'));
Sandhya
*From:* Liu, Ming (Ming) [mailto:ming@esgyn.cn]
*Sent:* Tuesday, February 16, 2016 6:34 AM
*To:* user@trafodion.incubator.apache.org
*Subject:* how to use BLOB/CLOB
Hi, all,
I am interested about how can a user use BLOB/CLOB in Trafodion?
I see usage of stringtolob() and lobtostring() like this:
insert into tbl values(1,stringtolob('clob values'));
select lobtostring(c2,10) from tbl;
This is fine if I have not too long string, but if I have a big text file