Class AzureSynapseAnalyticsSchema.NodesColumnStoreSegment
- Namespace
- LinqToDB.Tools.DataProvider.SqlServer.Schemas
- Assembly
- linq2db.Tools.dll
sys.pdw_nodes_column_store_segments (Transact-SQL)
Applies to: √ Azure Synapse Analytics √ Analytics Platform System (PDW)
Contains a row for each column in a columnstore index.
[Table(Schema = "sys", Name = "pdw_nodes_column_store_segments", IsView = true)]
public class AzureSynapseAnalyticsSchema.NodesColumnStoreSegment- Inheritance
-
AzureSynapseAnalyticsSchema.NodesColumnStoreSegment
- Extension Methods
Properties
BaseID
Base value ID if encoding type 1 is being used. If encoding type 1 is not being used, base_id is set to 1.
[Column("base_id")]
[NotNull]
public long BaseID { get; set; }Property Value
ColumnID
ID of the columnstore column.
[Column("column_id")]
[NotNull]
public int ColumnID { get; set; }Property Value
EncodingType
Type of encoding used for that segment:
1 = VALUE_BASED - non-string/binary with no dictionary (similar to 4 with some internal variations)
2 = VALUE_HASH_BASED - non-string/binary column with common values in dictionary
3 = STRING_HASH_BASED - string/binary column with common values in dictionary
4 = STORE_BY_VALUE_BASED - non-string/binary with no dictionary
5 = STRING_STORE_BY_VALUE_BASED - string/binary with no dictionary
All encodings take advantage of bit-packing and run-length encoding when possible.
[Column("encoding_type")]
[NotNull]
public int EncodingType { get; set; }Property Value
HasNulls
1 if the column segment has null values.
[Column("has_nulls")]
[NotNull]
public int HasNulls { get; set; }Property Value
HoBTID
ID of the heap or B-tree index (hobt) for the table that has this columnstore index.
[Column("hobt_id")]
[NotNull]
public long HoBTID { get; set; }Property Value
Magnitude
Magnitude if encoding type 1 is being used. If encoding type 1 is not being used, magnitude is set to 1.
[Column("magnitude")]
[NotNull]
public double Magnitude { get; set; }Property Value
MaxDataID
Maximum data ID in the column segment.
[Column("max_data_id")]
[NotNull]
public long MaxDataID { get; set; }Property Value
MinDataID
Minimum data ID in the column segment.
[Column("min_data_id")]
[NotNull]
public long MinDataID { get; set; }Property Value
NullValue
Value used to represent nulls.
[Column("null_value")]
[NotNull]
public long NullValue { get; set; }Property Value
OnDiskSize
Size of segment in bytes.
[Column("on_disk_size")]
[NotNull]
public long OnDiskSize { get; set; }Property Value
PartitionID
Indicates the partition ID. Is unique within a database.
[Column("partition_id")]
[NotNull]
public long PartitionID { get; set; }Property Value
PdwNodeID
Unique identifier of a Azure Synapse Analytics node.
[Column("pdw_node_id")]
[NotNull]
public int PdwNodeID { get; set; }Property Value
PrimaryDictionaryID
ID of primary dictionary. A non-zero value points to the local dictionary for this column in the current segment (i.e. the rowgroup). A value of -1 indicates that there is no local dictionary for this segment.
[Column("primary__dictionary_id")]
[NotNull]
public int PrimaryDictionaryID { get; set; }Property Value
RowCount
Number of rows in the row group.
[Column("row_count")]
[NotNull]
public int RowCount { get; set; }Property Value
SecondaryDictionaryID
ID of secondary dictionary. A non-zero value points to the local dictionary for this column in the current segment (i.e. the rowgroup). A value of -1 indicates that there is no local dictionary for this segment.
[Column("secondary_dictionary_id")]
[NotNull]
public int SecondaryDictionaryID { get; set; }Property Value
SegmentID
ID of the column segment. For backward compatibility, the column name continues to be called segment_id even though this is the rowgroup ID. You can uniquely identify a segment using <hobt_id, partition_id, column_id>, <segment_id>.
[Column("segment_id")]
[NotNull]
public int SegmentID { get; set; }Property Value
Version
Version of the column segment format.
[Column("version")]
[NotNull]
public int Version { get; set; }