The storage format specification defines a file format that transmits and stores the values along with a common schema. It also defines certain processes for operating on and compressing the storage format data.
You can perform algorithmic compression on DATASET data using the SNAPPY_COMPRESS and SNAPPY_DECOMPRESS routines.
You can only use SNAPPY_COMPRESS and SNAPPY_DECOMPRESS to compress DATASET data. If you use any other algorithmic compression routines, you will get an error.
For storage format AVRO:
CREATE TABLE avroCompressTable( id INTEGER, compressibleAvroFile DATASET STORAGE FORMAT AVRO COMPRESS USING SNAPPY_COMPRESS DECOMPRESS USING SNAPPY_DECOMPRESS);
For storage format CSV:
CREATE TABLE csvCompressTable( id INTEGER, compressibleCSVFile DATASET STORAGE FORMAT CSV COMPRESS USING SNAPPY_COMPRESS DECOMPRESS USING SNAPPY_DECOMPRESS);
For more information about algorithmic compression, see Teradata Vantageā¢ - Data Types and Literals, B035-1143.