INSERT-SELECT Statements for Time Series Tables | Teradata Vantage - INSERT-SELECT - Advanced SQL Engine - Teradata Database

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'.