Support Questions

Find answers, ask questions, and share your expertise

Nifi CDC on UDB table with CLOB using QueryDatabaseTableRecord Avro not parsing Clob

Explorer

I am working on a flow that will capture new records in the UDB table. I am using QueryDatabaseTableRecord processor with  AvroRecordSetWriter. The problem I am facing is a column I need is defined as a CLOB in the table. I cannot figure out what is the appropriate way to pull back that column from the table. I have not found a mapping to CLOB in the avro datatypes. The error it gives is IllegalTypeConversionException. Is there another reader is should be using, or can this work somehow with Avro? Thanks!

 

0 REPLIES 0
Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.