Incompatible data type for properly set column
Posted: Thu May 17, 2018 7:28 am
Hi,
I seem to be having an issue with a source query and its column definitions. Using the netezza connector, the columns defined were all done by hand, not imported from a table definition. I had assumed that certain data types that are NULL from the source, such as SELECT NULL as Column1 FROM TABLE, would need to be cast as the datatype the column is defined to be, however I found that this is not the case. As you can see in the source query I tried this and it made no difference and there are other columns of the same data types that are NULL and are not cast that do not present issues.
Here is the source query:
https://github.com/jacksoneyton/DataSta ... rceQry.sql
Here is an export of the table definitions:
https://github.com/jacksoneyton/DataSta ... mnDefs.dsx
And here is the first error in the job log:
https://github.com/jacksoneyton/DataSta ... r/ErrorLog
I'm quite confused as to what is going on here
I seem to be having an issue with a source query and its column definitions. Using the netezza connector, the columns defined were all done by hand, not imported from a table definition. I had assumed that certain data types that are NULL from the source, such as SELECT NULL as Column1 FROM TABLE, would need to be cast as the datatype the column is defined to be, however I found that this is not the case. As you can see in the source query I tried this and it made no difference and there are other columns of the same data types that are NULL and are not cast that do not present issues.
Here is the source query:
https://github.com/jacksoneyton/DataSta ... rceQry.sql
Here is an export of the table definitions:
https://github.com/jacksoneyton/DataSta ... mnDefs.dsx
And here is the first error in the job log:
https://github.com/jacksoneyton/DataSta ... r/ErrorLog
I'm quite confused as to what is going on here