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.