Hello and thanks in advance. I have KNIME 3.4.1 on Windows.
I'm very new to KNIME, but have successfully set up my Netezza driver in the Database Preferences section (via pointing to the nzjdbc.jar file). I've also successfully connected to my Netezza SQL database and can retrieve some queries without issue.
In some cases, I get the following error on the 'Database Table Connector' > 'Database Connection Table Reader' node setup:
ERROR Database Connection Table Reader SQL Exception reading Object of type "-9": netezza.feature.not.supported - all further errors are suppressed and reported on debug level only
I believe I've narrowed the issue to certain fields that are setup as VARCHARS or other String types, but don't see a particular pattern. Is there any other node setup that would get around this? Thanks!