16.20 - UPDATE (Upsert Form) - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ Time Series Tables and Operations

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Programming Reference
Publication ID
B035-1208-162K
Language
English (United States)
Last Update
2019-05-02

You cannot perform an isolated load on a PTI table.

You cannot specify the DEFAULT VALUES option to update a PTI table.

For complete information about UPDATE (Upsert Form), see Teradata Vantage™ SQL Data Manipulation Language , B035-1146 .

UPDATE (Upsert) Rules and Restrictions

You cannot specify the system generated TD_TIMEBUCKET column in the UPDATE (Upsert Form) statement.

You cannot update the system generated columns TD_TIMEBUCKET, TD_TIMEBUCKET, or TD_SEQNO in an UPDATE (Upsert Form) statement. Also, you cannot update any of the columns defined in the COLUMNS specification of the PRIMARY TIME INDEX.

The WHERE clause must include equality predicate on the following columns to match a single row for updating:
  • TD_TIMECODE column
  • TD_SEQNO column, for sequenced PTI tables
  • All of the columns defined in the COLUMNS specification of the PRIMARY TIME INDEX.

If a match cannot be found, an insert operation is performed.