You can insert rows into a PTI table using INSERT SELECT syntax. See INSERT and 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'.