Modifying DATASET Columns | Teradata Vantage - Modifying DATASET Columns - Analytics Database - Teradata Vantage

DATASET Data Type

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-10-30
dita:mapPath
bka1628112240653.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ekk1458586304878
lifecycle
latest
Product Category
Teradata Vantageā„¢

The INSERT-SELECT statement supports inserting a value to a DATASET data type column of any storage format. You can select and use a source table with a DATASET column whose data length is compatible with the DATASET data type column of the target table as a source value to the INSERT-SELECT operation. The source table must also have the same storage format as the target column.

If the source data is larger than the maximum possible length of the target DATASET data type column, an error occurs.

The data stored in the source table must contain a schema, so you do not need to specify a schema in the INSERT-SELECT statement. If you want the target table to store the data with an updated schema, the target column must have a schema specified. The schema specified in this location overwrites any schema specified for the source data, so be careful to ensure the new schema correctly describes the source data.