| title | sys.pdw_nodes_column_store_dictionaries (Transact-SQL) | |
|---|---|---|
| description | sys.pdw_nodes_column_store_dictionaries (Transact-SQL) | |
| author | WilliamDAssafMSFT | |
| ms.author | wiassaf | |
| ms.date | 03/03/2017 | |
| ms.service | sql | |
| ms.subservice | data-warehouse | |
| ms.topic | reference | |
| dev_langs |
|
|
| monikerRange | >=aps-pdw-2016||=azure-sqldw-latest |
[!INCLUDEapplies-to-version/asa-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 [!INCLUDEssazuresynapse-md] node. |
Requires VIEW SERVER STATE permission.
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)