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

Does Impala support XMLTYPE and BLOB

Does Impala support XMLTYPE and BLOB

New Contributor

Hello Team,

 

we are currently loading data from different Oracle sources to Kudu. I have used STRING datatype for XMLTYPE and BLOB columns. I see the values become NULL after initial load.

 

Kindly advise for an alternative.

 

I have attached a sample content of a field with datatype XMLTYPE.

 

Thanks,

 

Roshan

 


XMLTYPE.PNG
1 REPLY 1

Re: Does Impala support XMLTYPE and BLOB

There's a 64kb limit on strings in Kudu but otherwise you can store any binary data in them.

 

https://docs.cloudera.com/documentation/kudu/5-10-x/topics/kudu_known_issues.html#schema_design_limi...