Class TableDistStyle
(experimental) The data distribution style of a table.
Inheritance
Namespace: Amazon.CDK.AWS.Redshift
Assembly: Amazon.CDK.AWS.Redshift.dll
Syntax (csharp)
public sealed class TableDistStyle : Enum
Syntax (vb)
Public NotInheritable Class TableDistStyle
Inherits
Enum
Remarks
Stability: Experimental
ExampleMetadata: fixture=cluster infused
Examples
new Table(this, "Table", new TableProps {
TableColumns = new [] { new Column { Name = "col1", DataType = "varchar(4)", DistKey = true }, new Column { Name = "col2", DataType = "float" } },
Cluster = cluster,
DatabaseName = "databaseName",
DistStyle = TableDistStyle.KEY
});
Synopsis
Fields
ALL | (experimental) A copy of the entire table is distributed to every node. |
AUTO | (experimental) Amazon Redshift assigns an optimal distribution style based on the table data. |
EVEN | (experimental) The data in the table is spread evenly across the nodes in a cluster in a round-robin distribution. |
KEY | (experimental) The data is distributed by the values in the DISTKEY column. |
value__ |
Fields
ALL
(experimental) A copy of the entire table is distributed to every node.
public const TableDistStyle ALL
Field Value
Type | Description |
---|---|
TableDistStyle |
Remarks
Stability: Experimental
AUTO
(experimental) Amazon Redshift assigns an optimal distribution style based on the table data.
public const TableDistStyle AUTO
Field Value
Type | Description |
---|---|
TableDistStyle |
Remarks
Stability: Experimental
EVEN
(experimental) The data in the table is spread evenly across the nodes in a cluster in a round-robin distribution.
public const TableDistStyle EVEN
Field Value
Type | Description |
---|---|
TableDistStyle |
Remarks
Stability: Experimental
KEY
(experimental) The data is distributed by the values in the DISTKEY column.
public const TableDistStyle KEY
Field Value
Type | Description |
---|---|
TableDistStyle |
Remarks
Stability: Experimental
value__
public int value__
Field Value
Type | Description |
---|---|
System.Int32 |