Primary indexes for temporal tables must be non-unique (NUPIs).
Temporal columns, or the component columns of temporal derived period columns, cannot be included in primary indexes or primary AMP indexes.
If the CREATE TABLE statement for a nonpartitioned table does not specify either PRIMARY INDEX, PRIMARY AMP INDEX, or NOPI, automatic creation of a primary index is controlled by the setting of DBS Control field PrimaryIndexDefault. For more information see Teradata Vantage™ - Database Utilities, B035-1102.
If the CREATE TABLE statement for a partitioned table does not specify either PRIMARY INDEX, PRIMARY AMP INDEX, or NO PRIMARY INDEX, the table will be created as a NoPI table.