Usage Notes for CREATE TABLE AS (PTI table form) | Teradata Vantage - Usage Notes - Analytics Database - Teradata Vantage
Time Series Tables and Operations
- Deployment
- VantageCloud
- VantageCore
- Edition
- Enterprise
- IntelliFlex
- VMware
- Product
- Analytics Database
- Teradata Vantage
- Release Number
- 17.20
- Published
- June 2022
- Language
- English (United States)
- Last Update
- 2023-10-30
- dita:mapPath
- tuc1628112453431.ditamap
- dita:ditavalPath
- qkf1628213546010.ditaval
- dita:id
- sfz1493079039055
- lifecycle
- latest
- Product Category
- Teradata Vantage™
- The source table, target table, or both can be PTI tables.
- If you specify a PRIMARY TIME INDEX clause, the automatically generated columns and their characteristics in the target table are determined by the PRIMARY TIME INDEX clause options, regardless of these columns and characteristics in the source PTI table.
- If you create a non-PTI target table from a PTI source table, any automatically generated columns from the source PTI table are created in the target table, however they are no longer managed by Vantage, and their definitions do not include the GENERATED [SYSTEM] TIMECOLUMN attribute from the source PTI table.
- Timestamps in a source PTI table cannot be prior to the timezero_date of the PRIMARY TIME INDEX clause.
- Sequence numbers of rows in a source PTI table cannot exceed the seq_max of the PRIMARY TIME INDEX clause.