16.20 - Tools and Utilities for PTI Tables - 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
Language
English (United States)
Last Update
2019-05-02
dita:mapPath
wne1515028094879.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

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 Teradata Database 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 ARC and 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.