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)