Sunday, 1 November 2015

Partitioning Techniques

div dir="ltr" style="text-align: left;" trbidi="on">

Partitioning Techniques


In this data partitioning method the data splits into various partitions distribute across the processors.
     The data partitioning techniques are
a)    Auto
b)    Hash
c)     Modulus
d)    Random
e)    Range
f)     Round Robin
g)    Same

The default partition technique is Auto.

Round Robin:-  the first record goes to first processing node, second record goes to the second processing node and so on….. This method is useful for creating equal size of partition.
Hash:- The records with the same values for the hash-key field given to the same processing node.
Modulus:- This partition is based on key column module. This partition is similar to hash partition.
Random:- The records are randomly distributed across all processing nodes.
Range:- The related records are distributed across the one node . The range is specified based on key column.

Auto:- This is most common method. The data stage determines the best partition method to use depending upon the type of stage.

No comments:

Post a Comment