16.20 - INSERT-SELECT - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ Time Series Tables and Operations

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Programming Reference
Publication ID
B035-1208-162K
Language
English (United States)
Last Update
2019-05-02

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