Given two tables stored on HIVE 1. party (contains party_name, consituency_name) 2. constituency (consituency_name, improvement_description, year,...

Transcribed Image Text:

Given two tables stored on HIVE 1. party (contains party_name, consituency_name) 2. constituency (consituency_name, improvement_description, year, date) - logs every improvement made in a constituency We need to find out the total number of improvements made by different political parties in a 2018. For example, how many improvements did ModernParty make in 2018. (i) design a HIVE SQL query to achieve this objective(exact syntax is not neessary. Important to get the logic right). (ii) illustrate through a DAG, how HIVE will translate this query through a series of Map Reduce steps to execute this query. Given two tables stored on HIVE 1. party (contains party_name, consituency_name) 2. constituency (consituency_name, improvement_description, year, date) - logs every improvement made in a constituency We need to find out the total number of improvements made by different political parties in a 2018. For example, how many improvements did ModernParty make in 2018. (i) design a HIVE SQL query to achieve this objective(exact syntax is not neessary. Important to get the logic right). (ii) illustrate through a DAG, how HIVE will translate this query through a series of Map Reduce steps to execute this query.