What Is The Difference Between Partitioning With Key / Hash And Round

1.	What Is The Difference Between Partitioning With Key / Hash And Round Robin?
Answer» Partitioning by Key / Hash Partition : The partitioning technique that is used when the KEYS are diverse Large data skew can EXIST when the key is present in large volume It is apt for parallel data processing Round Robin Partition : This partition technique uniformly distributed the data on every DESTINATION data partitions When number of records is DIVISIBLE by number of partitions, then the skew is zero. For example: a pack of 52 cards is distributed among 4 players in a round-robin fashion. Partitioning by Key / Hash Partition : Round Robin Partition : For example: a pack of 52 cards is distributed among 4 players in a round-robin fashion.

What Is The Difference Between Partitioning With Key / Hash And Round Robin?

Answer»

Partitioning by Key / Hash Partition :

Round Robin Partition :

This partition technique uniformly distributed the data on every DESTINATION data partitions
When number of records is DIVISIBLE by number of partitions, then the skew is zero.

For example: a pack of 52 cards is distributed among 4 players in a round-robin fashion.

Partitioning by Key / Hash Partition :

Round Robin Partition :

For example: a pack of 52 cards is distributed among 4 players in a round-robin fashion.