Problem

Hyper-Q reports the error message DTM3103: Cannot insert the value NULL into column.

Cause

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.

Solution

To solve this problem:

1. Confirm this issue by running the SELECT statement that is attempting to populate the table or update a field and examine the results.
2. Once a partial or the full source of the NULL values is identified, work with a database administrator to resolve the issue.