1.1 - DISTRIBUTIONTYPE - Teradata Vantage

Teradata Vantageā„¢ User Guide

prodname
Teradata Vantage
vrm_release
1.1
created_date
May 2020
category
User Guide
featnum
B700-4002-079K
Some ML Engine functions create temporary tables for internal processing. The distribution key (partition key) column of such tables is decided based on function arguments specified by the user. The data type of such columns must belong to SQL 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)