Teradata Database Message 5758 - 5758 - 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 search condition must fully specify the Target table primary index and partition column(s) and expression must match INSERT specification primary index and partition column(s).
- Explanation
- The search condition must fully specify an equality constraint on the primary index and partition column(s) between the source and target table. Other set of conditions must be ANDed with primary index and partition column conditions. If an expression/column is selected for the target primary index in the INSERT part of the MERGE statement, that expression must be matched with the target primary index on the ON clause. Expression should also not involve a non-deterministic UDF/UDM or RANDOM function
- Generated By
- Parser.
- For Whom
- End User.
- Notes
- None
- Remedy
- Correct the MERGE statement and resubmit.