GEP interview question

Spark, Python, Hive , SQL, Puzzles