Assignment: Inspect the following datasets on the accessed web site, and create suitable Hive tables under your…

Inspect the following datasets on the accessed web site, and create suitable Hive tables under your schema to receive the data they hold:2013 Grid Emissions Survey (https://data.london.gov.uk/dataset/london-atmospheric-emissions-inventory-2013/resource/0fa6a83a-1529-48a7-890d-414a2f52b0e6)2013 Detailed Road Transport Emissions by link (https://data.london.gov.uk/dataset/london-atmospheric-emissions-inventory-2013/resource/8c520de2-c518-4e64-932c-0071ac826742)
From copies of the dataset already on the cluster, use the “Load data” Hive command to ingest all rows of each of the datasets into the target tables.
Using relevant Hive DML statements and summary functions (e.g. max, min, count or avg), generate at least two reports that summarise the data in the two tables in an insightful way. Explain your rationale for producing those particular report summaries.