'When are Keys Not Sortable in Sort Merge Join in Spark?

When I read articles on Sort Merge Join, it says this is the most preferred one in spark after Broadcast join, but only if joining keys are sortable. My question is when can a joining key be unsortable? Any datatype can be sorted. Could you help me understand a scenario where keys may not be sortable?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source