$(2)$ Big Data Query & Analysis by Apache Hive $[30$ marks$]$

This task is using Apache Hive for converting big raw data into useful information for the

end users. To do so$,$ firstly understand the dataset carefully. Then, make at least $4$ Hive

queries $($refer to the marking scheme$).$ Apply appropriate visualization tools to present

your findings numerically and graphically. Interpret shortly your findings.

Finally, take screenshot of your outcomes $($e$.$g$.,$ tables and plots$)$ together with the

scripts$/$queries into the report.

Tip: The mark for this section depends on the level of your HIVE queries$$ complexities, for

instance using the simple select query is not supposed for full mark.