Class ColumnEncoding
(experimental) The compression encoding of a column.
Inheritance
Namespace: Amazon.CDK.AWS.Redshift.Alpha
Assembly: Amazon.CDK.AWS.Redshift.Alpha.dll
Syntax (csharp)
public sealed class ColumnEncoding : Enum
Syntax (vb)
Public NotInheritable Class ColumnEncoding
Inherits
Enum
Remarks
Stability: Experimental
See: https://docs.aws.amazon.com/redshift/latest/dg/c_Compression_encodings.html
ExampleMetadata: fixture=cluster infused
Examples
using Amazon.CDK.AWS.Redshift.Alpha;
new Table(this, "Table", new TableProps {
TableColumns = new [] { new Column { Name = "col1", DataType = "varchar(4)", Encoding = ColumnEncoding.TEXT32K }, new Column { Name = "col2", DataType = "float", Encoding = ColumnEncoding.DELTA32K } },
Cluster = cluster,
DatabaseName = "databaseName"
});
Synopsis
Fields
AUTO | (experimental) Amazon Redshift assigns an optimal encoding based on the column data. |
AZ64 | (experimental) The column is compressed using the AZ64 algorithm. |
BYTEDICT | (experimental) The column is compressed using a separate dictionary for each block column value on disk. |
DELTA | (experimental) The column is compressed based on the difference between values in the column. |
DELTA32K | (experimental) The column is compressed based on the difference between values in the column. |
LZO | (experimental) The column is compressed using the LZO algorithm. |
MOSTLY16 | (experimental) The column is compressed to a smaller storage size than the original data type. |
MOSTLY32 | (experimental) The column is compressed to a smaller storage size than the original data type. |
MOSTLY8 | (experimental) The column is compressed to a smaller storage size than the original data type. |
RAW | (experimental) The column is not compressed. |
RUNLENGTH | (experimental) The column is compressed by recording the number of occurrences of each value in the column. |
TEXT255 | (experimental) The column is compressed by recording the first 245 unique words and then using a 1-byte index to represent each word. |
TEXT32K | (experimental) The column is compressed by recording the first 32K unique words and then using a 2-byte index to represent each word. |
value__ | |
ZSTD | (experimental) The column is compressed using the ZSTD algorithm. |
Fields
AUTO
(experimental) Amazon Redshift assigns an optimal encoding based on the column data.
public const ColumnEncoding AUTO
Field Value
Type | Description |
---|---|
ColumnEncoding |
Remarks
This is the default.
Stability: Experimental
AZ64
(experimental) The column is compressed using the AZ64 algorithm.
public const ColumnEncoding AZ64
Field Value
Type | Description |
---|---|
ColumnEncoding |
Remarks
Stability: Experimental
See: https://docs.aws.amazon.com/redshift/latest/dg/az64-encoding.html
BYTEDICT
(experimental) The column is compressed using a separate dictionary for each block column value on disk.
public const ColumnEncoding BYTEDICT
Field Value
Type | Description |
---|---|
ColumnEncoding |
Remarks
Stability: Experimental
See: https://docs.aws.amazon.com/redshift/latest/dg/c_Byte_dictionary_encoding.html
DELTA
(experimental) The column is compressed based on the difference between values in the column.
public const ColumnEncoding DELTA
Field Value
Type | Description |
---|---|
ColumnEncoding |
Remarks
This records differences as 1-byte values.
Stability: Experimental
See: https://docs.aws.amazon.com/redshift/latest/dg/c_Delta_encoding.html
DELTA32K
(experimental) The column is compressed based on the difference between values in the column.
public const ColumnEncoding DELTA32K
Field Value
Type | Description |
---|---|
ColumnEncoding |
Remarks
This records differences as 2-byte values.
Stability: Experimental
See: https://docs.aws.amazon.com/redshift/latest/dg/c_Delta_encoding.html
LZO
(experimental) The column is compressed using the LZO algorithm.
public const ColumnEncoding LZO
Field Value
Type | Description |
---|---|
ColumnEncoding |
Remarks
Stability: Experimental
See: https://docs.aws.amazon.com/redshift/latest/dg/lzo-encoding.html
MOSTLY16
(experimental) The column is compressed to a smaller storage size than the original data type.
public const ColumnEncoding MOSTLY16
Field Value
Type | Description |
---|---|
ColumnEncoding |
Remarks
The compressed storage size is 2 bytes.
Stability: Experimental
See: https://docs.aws.amazon.com/redshift/latest/dg/c_MostlyN_encoding.html
MOSTLY32
(experimental) The column is compressed to a smaller storage size than the original data type.
public const ColumnEncoding MOSTLY32
Field Value
Type | Description |
---|---|
ColumnEncoding |
Remarks
The compressed storage size is 4 bytes.
Stability: Experimental
See: https://docs.aws.amazon.com/redshift/latest/dg/c_MostlyN_encoding.html
MOSTLY8
(experimental) The column is compressed to a smaller storage size than the original data type.
public const ColumnEncoding MOSTLY8
Field Value
Type | Description |
---|---|
ColumnEncoding |
Remarks
The compressed storage size is 1 byte.
Stability: Experimental
See: https://docs.aws.amazon.com/redshift/latest/dg/c_MostlyN_encoding.html
RAW
(experimental) The column is not compressed.
public const ColumnEncoding RAW
Field Value
Type | Description |
---|---|
ColumnEncoding |
Remarks
Stability: Experimental
See: https://docs.aws.amazon.com/redshift/latest/dg/c_Raw_encoding.html
RUNLENGTH
(experimental) The column is compressed by recording the number of occurrences of each value in the column.
public const ColumnEncoding RUNLENGTH
Field Value
Type | Description |
---|---|
ColumnEncoding |
Remarks
Stability: Experimental
See: https://docs.aws.amazon.com/redshift/latest/dg/c_Runlength_encoding.html
TEXT255
(experimental) The column is compressed by recording the first 245 unique words and then using a 1-byte index to represent each word.
public const ColumnEncoding TEXT255
Field Value
Type | Description |
---|---|
ColumnEncoding |
Remarks
Stability: Experimental
See: https://docs.aws.amazon.com/redshift/latest/dg/c_Text255_encoding.html
TEXT32K
(experimental) The column is compressed by recording the first 32K unique words and then using a 2-byte index to represent each word.
public const ColumnEncoding TEXT32K
Field Value
Type | Description |
---|---|
ColumnEncoding |
Remarks
Stability: Experimental
See: https://docs.aws.amazon.com/redshift/latest/dg/c_Text255_encoding.html
value__
public int value__
Field Value
Type | Description |
---|---|
System.Int32 |
ZSTD
(experimental) The column is compressed using the ZSTD algorithm.
public const ColumnEncoding ZSTD
Field Value
Type | Description |
---|---|
ColumnEncoding |
Remarks
Stability: Experimental
See: https://docs.aws.amazon.com/redshift/latest/dg/zstd-encoding.html