Oracle XMLTYPE/BLOB/CLOB to Kudu

[Roshan]

Oracle DB 12.1.0.2

Hello Erman,

XMLTYPE/CLOB and BLOB datatypes are not supported on Kudu.

Can you please suggest how to replicate these fields from Oracle to Kudu?

Thanks,

Roshan

[ErmanArslansOracleBlog]

I guess you will write them as binary,sting type..
I don't know which tool you use here, but you need to make that conversion.

This is also written in Striim Kudu writer documentation.

https://www.striim.com/docs/en/kudu-writer.html

[Roshan]

Hi,

I tried the date conversions from the Kudu writer documentation. I think I will check with Cloudera since the data type (binary) does not seem to work on Kudu.

[ErmanArslansOracleBlog]

The following page says, binary is a supported column type in Kudu ->

https://kudu.apache.org/docs/schema_design.html