Tools and Utilities for PTI Tables | Teradata Vantage - 17.10 - Tools and Utilities for PTI Tables - 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)

Most Teradata tools and utilities support PTI tables as they support non-PTI tables, with the following exceptions:

Load and Unload Utilities

  • Teradata MultiLoad cannot be used to load PTI tables.
  • Teradata Parallel Transporter, Teradata FastLoad, Teradata FastExport, and Teradata TPump support loading data to, and unloading data from PTI tables.
    • To load data using an INSERT statement, follow the same rules used for MERGE WHEN NOT MATCH INSERT (see MERGE).
    • For a single row update/insert on a PTI table, follow the UPDATE (Upsert Form) guidelines.
    The TD_TIMEBUCKET column is automatically generated and managed by Vantage as necessary for PTI tables. It is invisible to users and DML. Therefore, never attempt to load or insert data that includes values for the TD_TIMEBUCKET column of a PTI table.

Archive and Restore

You can use DSA to archive, restore, and copy PTI tables. If a PTI table is copied or restored from one system to another, use ALTER TABLE REVALIDATE to revalidate the PTI tables after restoring.