Teradata Database Message 5742 - 5742 - Analytics Database - Teradata Vantage

Teradata® VantageCloud Lake - Analytics Database Messages

Edition
Lake
Product
Analytics Database
Teradata Vantage
Published
October 2022
Language
English (United States)
Last Update
2024-02-26
dita:mapPath
tzr1629746512312.ditamap
dita:ditavalPath
ft:empty
dita:id
vza1585613049811
lifecycle
latest
Product Category
Teradata® Vantage™
Message
The UPDATE part of the UPSERT does not fully specify values for the partitioning columns.
Explanation
The UPDATE part of the UPSERT statement must fully specify values for all the partitioning columns by specifying an equality constraint on each of the partitioning columns to an expression having the same data type and not containing column references.
Generated By
Parser.
For Whom
End User.
Notes
None
Remedy
Correct the UPSERT statement and resubmit.