sys.pdw_nodes_column_store_dictionaries (Transact-SQL)
Applies to:
Azure Synapse Analytics
Analytics Platform System (PDW)
Contains a row for each dictionary used in columnstore indexes. Dictionaries are used to encode some, but not all data types, therefore not all columns in a columnstore index have dictionaries. A dictionary can exist as a primary dictionary (for all segments) and possibly for other secondary dictionaries used for a subset of the column's segments.
Column name | Data type | Description |
---|---|---|
partition_id | bigint | Indicates the partition ID. Is unique within a database. |
hobt_id | bigint | ID of the heap or B-tree index (HoBT) for the table that has this columnstore index. |
column_id | int | ID of the columnstore column. |
dictionary_id | int | Id of the dictionary. |
version | int | Version of the dictionary format. |
type | int | Dictionary type: 1 - Hash dictionary containing int values 2 - Not used 3 - Hash dictionary containing string values 4 - Hash dictionary containing float values |
last_id | int | The last data id in the dictionary. |
entry_count | bigint | Number of entries in the dictionary. |
on_disk_size | bigint | Size of dictionary in bytes. |
pdw_node_id | int | Unique identifier of a Azure Synapse Analytics node. |
Permissions
Requires VIEW SERVER STATE
permission.
See Also
Azure Synapse Analytics and Parallel Data Warehouse Catalog Views
CREATE COLUMNSTORE INDEX (Transact-SQL)
sys.pdw_nodes_column_store_segments (Transact-SQL)
sys.pdw_nodes_column_store_row_groups (Transact-SQL)
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho