INSERT-SELECT Statements for Time Series Tables | Teradata Vantage - 17.00 - INSERT-SELECT - 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 can insert rows into a PTI table using INSERT-SELECT syntax. See "INSERT/INSERT … SELECT" in Teradata Vantage™ - SQL Data Manipulation Language, B035-1146.

You can insert rows by selecting rows from a:

  • Non-PTI table and then insert the rows into a PTI table.
  • PTI table and then insert the rows into a non-PTI table.
  • PTI table and then insert the rows into another PTI table.

You cannot reference the TD_TIMEBUCKET column or insert values into the TD_TIMEBUCKET column using the INSERT-SELECT syntax. The TD_TIMEBUCKET column is a system generated column.

When performing an insert-select operation on a PTI table, the rows being inserted cannot have timecode value precedes the timezero specification in the primary time index of the PTI table, for example DATE '2016-01-01'.