Its completely differ. Hash key is used while the data/rows should be more than 2 key columns. Rows with same key column/ multiple key columns.
While coming to the sort stage is used for sort the data as ascending/descending. And produces a globally sorted sequential stream from with in partition sorted rows.
This is the major difference between sort and Hash partition techniques.
Its completely differ. Hash key is used while the data/rows should be more than 2 key columns. Rows with same key column/ multiple key columns.
ReplyDeleteWhile coming to the sort stage is used for sort the data as ascending/descending. And produces a globally sorted sequential stream from with in partition sorted rows.
This is the major difference between sort and Hash partition techniques.