Netezza : Importing potential null to not_nullable field
Posted: Fri Apr 15, 2011 3:18 pm
Hi
I'm trying to run querys in Netezza enterprise stage. It's giving me the following warning for almost all fields : "When checking operator: When validating import schema: At field "field_name": Importing potential null to not_nullable field".
I checked and the metadata (which I imported from the DB) is identical to the definition of the table in the database, so I don't understand why it's giving me that error. If I swap out the Netezza stage for an ODBC, it works just fine without any warning. The thing is that the Netezza stage is 5 times faster than ODBC but I just don't trust it since it's giving me these warnings.
I tried setting all fields nullability to "nullable" or "unknown" without any luck...
Any ideas how to get rid of it??
I'm trying to run querys in Netezza enterprise stage. It's giving me the following warning for almost all fields : "When checking operator: When validating import schema: At field "field_name": Importing potential null to not_nullable field".
I checked and the metadata (which I imported from the DB) is identical to the definition of the table in the database, so I don't understand why it's giving me that error. If I swap out the Netezza stage for an ODBC, it works just fine without any warning. The thing is that the Netezza stage is 5 times faster than ODBC but I just don't trust it since it's giving me these warnings.
I tried setting all fields nullability to "nullable" or "unknown" without any luck...
Any ideas how to get rid of it??