DISTRIBUTIONTYPE - Teradata Vantage

Teradata Vantageā„¢ User Guide

Product
Teradata Vantage
Release Number
1.1
Published
May 2020
Language
English (United States)
Last Update
2020-05-28
dita:mapPath
ioz1543440393126.ditamap
dita:ditavalPath
jsj1481748799576.ditaval
dita:id
B700-4002
lifecycle
previous
Product Category
Teradata Vantage
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)