INSERT Statement for Time Series Tables | Teradata Vantage - 17.10 - INSERT - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Time Series Tables and Operations

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1208-171K
Language
English (United States)
You use the INSERT statement to insert rows into PTI tables. PTI tables can be either of the following types:
  • Nonsequenced
  • Sequenced

PTI tables include the system generated TD_TIMECODE column. The TD_TIMECODE value must be the first value in the value list for inserts into nonsequenced and sequenced PTI tables. When inserting into a PTI table, the TD_TIMECODE value cannot precede the timezero value specified in the PTI definition, for example DATE '2016-10-15'.

Sequenced PTI tables also include the TD_SEQNO column. This must be the second value in the value list for inserts into a sequenced PTI table.

In sequenced tables, rows are ordered according the TD_TIMECODE value and then the TD_SEQNO value. Row ordering is automatic, so inserts can occur in any order.

The table below summarizes inserts into the system generated PTI table columns.

Column Description
TD_TIMECODE This is a system generated column for sequenced PTI tables.

This is a non-nullable column. You must provide a value.

This must be the first value in the value list for inserts.

You cannot provide CURRENT_TIMESTAMP, CURRENT_TIME, or CURRENT_DATE as a value.

TD_SEQNO This is a system generated column for sequenced PTI tables.

This is a non-nullable column. You must provide a value.

This must be the second value in the value list for inserts into a sequenced PTI table.

INSERT Restrictions

Isolated loading is not supported for inserts into PTI tables.

The DEFAULT VALUES option is not supported for inserts into PTI tables.