Value
Attributes
This parameter has the following attributes:
Attribute | Value |
|---|---|
Section | [ObjectPartition] |
Abbreviation | None |
Required? | No |
Valid values | The limit or boundary of the partition for the corresponding Column parameter |
Default value | None |
Usage
The value that you specify must be the same data type as the column of the corresponding Column parameter. If you specify more than one partition, the values that you specify must be unique and in ascending order in the configuration file.
The value represents the upper limit of the partition. The partition contains all keys less than or equal to the limit that you specify with the Value parameter.
The product supports the TIMESTAMP WITH TIME ZONE data type. Enter a value in local time; the product converts the time value to Coordinated Universal Time (UTC) when taking the following actions:
- Generating the partition key
- Before using the data to determine the partitioning group for distribution purposes
The product supports the use of columns defined as TIMESTAMP WITH TIME ZONE as part of a partitioning key with [ObjectPartition]. Enter a value that adheres to the proper format for the column type, using the precision and time zone offset.
Ensure that the column that you specify as the partitioning key resolves to a unique value within the length determined by your target DBMS. For more information, see Partition-key-length.