It is simple:
partitionColumnis a column which should be used to determine partitions.-
lowerBoundandupperBounddetermine range of values to be fetched. Complete dataset will use rows corresponding to the following query:SELECT * FROM table WHERE partitionColumn BETWEEN lowerBound AND upperBound -
numPartitionsdetermines number of partitions to be created. Range betweenlowerBoundandupperBoundis divided intonumPartitionseach with stride equal to:upperBound / numPartitions - lowerBound / numPartitionsFor example if:
lowerBound: 0upperBound: 1000-
numPartitions: 10
Stride is equal to 100 and partitions correspond to following queries:
SELECT * FROM table WHERE partitionColumn BETWEEN 0 AND 100SELECT * FROM table WHERE partitionColumn BETWEEN 100 AND 200...SELECT * FROM table WHERE partitionColumn BETWEEN 900 AND 1000