Which Partition techniques for which stage

[kstechno]

Hi I understood all the partition techniques.
Can any one tell me
which technique used for the which stages
and according to which situation which key based or key less techniques are used ( With small examples)

Thankyou

[ray.wurlod]

"The correct one" is the one to choose. Your poll is meaningless.

It's not about stage type, it's about data type of the key for which adjacency needs to be established (Modulus is only for use when the key is an integer of some kind, Hash is the other key-based algorithm to be used for all other data types).

Stage types that need key-partitioned data are those that rely on same key values being on the same partition. These include Join, Merge, Remove Duplicates and Aggregator and may include Transformer and Lookup (and others).

[kstechno]

"The correct one" is the one to choose. Your poll is meaningless.

It's not about stage type, it's about data type of the key for which adjacency needs to be established (Modulus is only for use wh ...

Hi ray thanks for your reply.
I think the way i asked in the poll is wrong one.

And I m not premium member of this website. So that I cant read your message reply.
Any way once again thanks for your reply.

[ds@tcs]

If key column datatype is text then we use Hash
if key column datatype numeric we use modulous
if one key column numeric and another text then also we use Hash
if both key columns numeric then we use Modulous.

because modulous can be performed only on numbers

[kstechno]

If key column datatype is text then we use Hash
if key column datatype numeric we use modulous
if one key column numeric and another text then also we use Hash
if both key columns numeric then we use Modulous.

because modulous can be performed only on numbers

thankyou shankar

[ray.wurlod]

And I m not premium member of this website. So that I cant read your message reply.

This link might help.