S01002
Error Code
S01002
Error Message
The new partition ranges specified in newRanges cannot overlap with the
existing partition ranges. RefId: S01002
Probable Causes
When using the function addRangePartitions
to add new partitions to
a partitioned database with RANGE domain, the partition range specified in
newRanges overlap with the current partitions in the database.
For example:
db=database(directory="dfs://rangedb", partitionType=RANGE, partitionScheme=0 50 100)
addRangePartitions(dbhandle=db, newRanges=50 100 150 200)
The partition range 50-100 overlaps with the existing partitions.
Solutions
Remove the overlapping ranges from newRanges and try again. You can check the
current partitioning scheme using the schema
function:
schema(database(directory="dfs://rangedb"))
// Returns partitionSchema->[0,50,100]
addRangePartitions(dbhandle=db, newRanges=100 150 200)
// Returns 2, meaning 2 partitions have been added