sudo hive CREATE database MStation; CREATE TABLE stationData (stationed int, zipcode int, latitude double, longitude double, stationname string); CREATE TABLE weatherReport (stationid int, temp double, humi double, precip double, year int, month string); LOAD DATA LOCAL INPATH '/home/cloudera/datastation/ stationData.txt' into table stationData; LOAD DATA LOCAL INPATH '/home/cloudera/datastation/ weatherReport.txt' into table weatherReport; SELECT S.zipcode, AVG(W.precip) FROM stationData S JOIN weatherReport W ON S.stationid = W.stationid GROUP BY S.zipcode; SELECT stationid, AVG(humi) FROM weatherReport GROUP BY stationid; SELECT stationid, MIN(temp), MAX(temp) FROM weatherReport WHERE year > 2000 GROUP BY stationid; SELECT S.zipcode, W.temp, W.month, W.year FROM stationData S JOIN weatherReport W ON S.stationid = W.stationid ORDER BY W.temp DESC LIMIT 10;