Q5Big Data Analytics
Question
2 marks
Give a use case for Spark SQL.
Answer
Spark SQL is utilized to execute mathematically massive, real-time interactive queries over Petabytes of JSON data stored in an HDFS Data Lake using standard SQL syntax.
A data scientist needs to violently calculate the average transaction value of 100 million credit card swipes from yesterday. Instead of writing 500 lines of complex Java MapReduce code, they simply write SELECT AVG(value) FROM transactions and Spark SQL mathematically executes it in memory in seconds.