Storing text more than 32762 chars in BigSQL Hadoop external table

Question

I want to store a text of size 70000, but BigSQL Hadoop extrernal table restricts maximum field length to 32762. I do not want to trim or split into multiple columns. Is there any other datatype that let's me to load the full data.

score 2 · Answer 1 · answered May 22 '20 at 05:19

2

You can use CLOB

String types in DB2

answered May 22 '20 at 05:19

juergen d

201,996
37
293
362

As you had mentioned CLOB can be used in actual tables. If I am looking to create external tables on top of Hadoop, it doesn't support CLOB. Any suggestions ? – Pari Sairam Mohan May 22 '20 at 05:50
@PariSairamMohan you should include that info in your question – Charles May 22 '20 at 05:55

Storing text more than 32762 chars in BigSQL Hadoop external table

1 Answers1