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.