How to store string data in BIGSQL table with length greater than VARCHAR(32k)

Question

The data beyond 32762 characters is getting truncated when I am loading the data in my BigSQL table. My table definition is as below :

CREATE hadoop TABLE schema_name.table_name ( column1 VARCHAR(50), column2 INTEGER, column3 STRING, loaddate TIMESTAMP ) STORED AS PARQUET;

The for column3 is getting truncated. Is there a way to store the full data?

score 0 · Answer 1 · answered May 28 '19 at 10:50

0

Maybe the CLOB is the answer you're looking for

answered May 28 '19 at 10:50

Chris

I had used the same but it gave me an error. Unfortunately BigSQL Hadoop table doesn't support CLOB datatype. – tavishbhagat May 28 '19 at 11:35

1 Answers1