16.20 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Operators and User-Defined Functions

Advanced SQL Engine
Teradata Database
Release Number
Release Date
April 2020
Content Type
Programming Reference
Publication ID
English (United States)

Numeric data types are valid when calling the function in an SQL statement, but not when using the function for ALC on a column.

If TD_LZ_COMPRESS is used with ALC, nulls are also compressed if those columns are nullable.

You can use the TD_LZ_COMPRESS function to compress JSON data; however, Teradata recommends that you use JSON_COMPRESS instead because the JSON_COMPRESS function is optimized for compressing JSON data.