Watch this video on YouTube
In Spark SQL, which of the following is necessary to perform a PIVOT operation?