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

Data type changes when querying Db2 database.

When i am querying as400 with queryDatabaseTable the nifi is changing the 'char' type from the source to 'binary' type so as a result useless data is coming.What could be the possible solution for this?I have already set use 'avro logical type' to false.

1 REPLY 1

It is going to be based on the JDBC type that the driver you are using is returning for the column...

https://github.com/apache/nifi/blob/master/nifi-nar-bundles/nifi-standard-bundle/nifi-standard-proce...

My guess is that its not returning CHAR because that would have been converted to a string.

The types that are converted to bytes are:

BINARY, VARBINARY, LONGVARBINARY, ARRAY, BLOB