There are length restrictions for the DATASET type.
A storage format must be specified. If not, the following error is reported:
Failure 3706 Syntax error: STORAGE FORMAT must be specified for the DATASET type.
Storage Format Restrictions
- Column level
Specify a schema at the column level if included in the CREATE or ALTER TABLE statement as an attribute of a DATASET data type column AND the schema was previously registered using the CREATE storage_format SCHEMA statement.
- Instance level
Specify a schema at the instance level if no schema has been specified at a higher level. The schema can be specified to apply to multiple instances of the data (for example, when batch loading similar data) using the CreateDATASET function.
By default, data is validated against the schema provided for an instance. This can reduce performance.
The DATASET data type may not be used as an attribute of a structured UDT or as the base type of a Teradata Distinct UDT or ARRAY type.
The DATASET data type may not be ordered, compared or grouped, so no ordering routine is provided.
You can use the DATASET data type like any other CDT data type, except in a relational comparison. Therefore, the DATASET data type cannot be used in an index definition and cannot be used in comparison expressions.
However, a portion of the DATASET instance may be selected out using provided system methods or functions. This portion may be used in a comparison operation within a query if the portion can be cast from a VARCHAR string to a comparable data type, compared as a VARCHAR, or be representative of another predefined, comparable type. The DATASET type cannot be compared, and therefore is not used for comparison in a SET table.