Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
What is the primary function of the PIVOT clause in Spark SQL?
A
To merge multiple rows into a single row by creating a wider table with more columns
B
To perform aggregation and convert rows into columns, transforming data from a long format to a wide format
C
To filter rows based on a specified condition
D
To split a single column into multiple columns based on column values
