INSERT SELECT Statements for Time Series Tables | Teradata Vantage - 17.10 - INSERT SELECT - 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 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'.