Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 5 (3 marks) Consider the files temperature.txt and location.txt already explained in Question 1. Assume, that the files have been already loaded into HDFS

image text in transcribed

Question 5 (3 marks) Consider the files temperature.txt and location.txt already explained in Question 1. Assume, that the files have been already loaded into HDFS and both of them are available at a location /bigdata/temperature. Write Pig-Latin statements that retrieve the following information. (1) Find the names of the cities, that recorded a temperature greater than 40 in at least one location on 28 December 2021. (1 mark) (2) Find the names of the cities, that have more than 5 locations where the temperature is recorded. (1 mark) (3) Find a date and city where the highest temperature ever has been recorded. (1 mark)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions