INSERT Statement for Time Series Tables | Teradata Vantage - 17.00 - INSERT - Teradata Database

Teradata Vantage™ - Time Series Tables and Operations

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-1208-170K
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.