Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Does Impala support XMLTYPE and BLOB

avatar
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

avatar

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...