usql.partition_parameters (U-SQL)
Summary
Provides details about the partition parameters for the partition schemes in the schemas of the current database context. The partitioned table must contain at least one record.
| Column name | Data type | Description |
|---|---|---|
| object_id_guid | Guid | Identifier of the object on which the partition is specified. |
| index_id | int | Identifier of the index for which the partition is specified. |
| parameter_id | int | Ordinal position (starting at 1) of the parameter (unique within a partition scheme). |
| column_id | int | Ordinal position of the column in the partition scheme |
Examples
The examples can be executed in Visual Studio with the Azure Data Lake Tools plug-in.
Query the usql.partitions view
USE TestReferenceDB;
OUTPUT usql.partition_parameters
TO "/ReferenceGuide/CatalogViews/partition_parameters.txt"
USING Outputters.Tsv(outputHeader:true);
Query the usql.partition_parameters view with other views
@partition_parameters =
SELECT o.name AS tableName,
c.name AS columnName,
p.partition_id_guid,
pp.*
FROM usql.partitions AS p
JOIN usql.objects AS o
ON p.object_id_guid == o.object_id_guid
JOIN usql.partition_parameters AS pp
ON p.object_id_guid == pp.object_id_guid
JOIN usql.columns AS c
ON o.object_id_guid == c.object_id_guid
AND pp.column_id == c.column_id;
OUTPUT @partition_parameters
TO "/ReferenceGuide/CatalogViews/partition_parameters_others.txt"
USING Outputters.Tsv(outputHeader:true);