Partition Key | Teradata Vantage - Partition Key - Teradata Vantage

Machine Learning User Guide

Product
Teradata Vantage
Release Number
9.01
1.3
Published
August 2020
Language
English (United States)
Last Update
2020-10-02
dita:mapPath
dci1595445931473.ditamap
dita:ditavalPath
dqp1599597541027.ditaval
dita:id
B700-4004
lifecycle
previous
Product Category
Teradata Vantageā„¢
The partition key of input/output tables for ML Engine functions must belong to data type group DISTRIBUTIONTYPE. The following data types belong to this group:
  • BIGINT
  • BLOB
  • BYTE(n)
  • CLOB
  • DECIMAL(p,s)
  • INTEGER
  • NUMERIC(p,s)
  • SMALLINT
  • VARBYTE(n)
  • VARCHAR(n)

This also applies to temporary tables created by some ML Engine functions for internal processing. The partitioning column of these tables is typically inherited from input tables and is exposed through a function syntax element. The data type of these columns must also be one of the data types mentioned above.