16.20 - CREATE FUNCTION and Multivalue Compression of UDT Columns - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
Language
English (United States)

You can use multivalue compression only for distinct UDTs based on the following predefined data types:

  • All numeric types.
  • DATE
  • CHARACTER and CHARACTER SET GRAPHIC
  • VARCHAR and CHARACTER SET VARGRAPHIC
  • BYTE
  • VARBYTE

You can specify the compression attributes COMPRESS NULL and NO COMPRESS for the following UDT data types:

  • Distinct and structured types that are not based on BLOB or CLOB types
  • ARRAY and VARRAY types
  • Period types