usql.partition_range_values (U-SQL)


Provides details about the range partition schemes for the partitioned tables in the schemas of the current database context. The partitioned table must contain at least one record.

Column name Data type Description
partition_id_guid Guid Identifier of the range partition
parameter_id int Ordinal position (starting at 1) of the parameter (unique within a partition scheme). Values in this column correspond to the parameter_id column of the usql.partition_parameters view for any particular partition_guid_id.
value string Lexical representation of the value


The examples can be executed in Visual Studio with the Azure Data Lake Tools plug-in.

Query the usql.partition_range_values view

USE TestReferenceDB;

OUTPUT usql.partition_range_values
TO "/ReferenceGuide/CatalogViews/partition_range_values.txt"
USING Outputters.Tsv(outputHeader:true);

Query the usql.partition_range_values view with other views

@partition_range_values =
    SELECT AS tableName,
   AS columnName,
    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
    JOIN usql.partition_range_values AS prv
    ON p.partition_id_guid == prv.partition_id_guid;

OUTPUT @partition_range_values
TO "/ReferenceGuide/CatalogViews/partition_range_values_others.txt"
USING Outputters.Tsv(outputHeader:true);  

See Also