Compression (Teradata Database) - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 2ADS Generation
Product
Teradata Warehouse Miner
Release Number
5.4.5
Published
February 2018
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
qhj1503087326201.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software

The following table lists the available compression functions, and a description of their purpose.

Embedded Services: Compression Functions
Function Description
CAMSET Compresses the specified Unicode character data into the following possible values using a proprietary Teradata algorithm:
  • partial byte values (for example, 4-bit digits or 5-bit alphabetic letters)
  • one byte values (for example, other Latin characters)
  • two byte values (for example, other Unicode characters)
CAMSET_L Compresses the specified Latin character data into the following possible values using a proprietary Teradata algorithm:
  • partial byte values (for example, 4-bit digits or 5-bit alphabetic letters)
  • one byte values (for example, other Latin characters)
DECAMSET Uncompresses the Unicode data that was compressed using the CAMSET function.
DECAMSET_L Uncompresses the Latin data that was compressed using the CAMSET_L function.
LZCOMP Compresses the specified Unicode character data using the Lempel-Ziv algorithm.
LZCOMP_L Compresses the specified Latin character data using the Lempel-Ziv algorithm.
LZDECOMP Uncompresses the Unicode data that was compressed using the LZCOMP function.
LZDECOMP_L Uncompresses the Latin data that was compressed using the LZCOMP_L function.
TD_LZ_COMPRESS Compresses any supported ALC data type or predefined type data using the Lempel-Ziv algorithm.
TD_LZ_DECOMPRESS Uncompresses predefined type data that was compressed using TD_LZ_COMPRESS or UDTs.
TS_COMPRESS Compresses TIME and TIMESTAMP with or without time zone to the minimum possible bytes.
TS_DECOMPRESS Uncompresses TIME and TIMESTAMP data with or without time zone that the TS_COMPRESS function compressed.
TransUnicodeToUTF8 Compress the specified Unicode character data into UTF8 format.
TransUTF8ToUnicode Uncompresses the Unicode data that was compressed using the TransUnicodeToUTF8 function.
See the Teradata Database SQL Functions, Operators, Expressions, and Predicates document, B035-1145, for a detailed overview of these compression functions.