DECOMPRESS USING - Teradata VantageCloud Lake

Lake - Working with SQL

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
jbe1714339405530.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
jbe1714339405530

Algorithmically decompress data in this column. For a list of data types that can be algorithmically compressed, see COMPRESS and DECOMPRESS Phrases.

To specify DECOMPRESS USING compress_UDF_name, the table cannot be populated with rows. 
The default containing database for decompress_UDF_name is SYSUDTLIB. If decompress_UDF_name is an embedded services UDF, then its default containing database is TD_SYSFNLIB. If decompress_UDF_name is not contained in SYSUDTLIB or TD_SYSFNLIB, Vantage returns an error to the requestor.

decompress_UDF_name
The name of the UDF to be used to algorithmically decompress data in this column.