Hyper-Q reports the error message
DTM3103: Cannot insert the value NULL into column.
Teradata table syntax does not allow columns to have a field specified as NOT NULL that prevents NULL data from being inserted. If this error is encountered, it indicates that the result set for an UPDATE or INSERT query is returning NULL for at least one column using NOT NULL.
To solve this problem:
- Confirm this issue by running the SELECT statement that is attempting to populate the table or update a field and examine the results.
- Once a partial or the full source of the NULL values is identified, work with a database administrator to resolve the issue.