EY interview question

Spark basics,Hive analytical functions, window functions, pivoting columns