Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Data type changes when querying Db2 database.

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
Highlighted

Re: Data type changes when querying Db2 database.

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

Don't have an account?
Coming from Hortonworks? Activate your account here