how to know which join type was used (broadcast, shuffle hash or sort merge join) for a query?

smoortema
Contributor

What is the best way to know what kind of join was used for a SQL query between broadcast, shuffle hash and sort merge? How can the spark UI or the query plan be interpreted?