pig script to show the most popular five star movies

mostPopularFiveStartMovies.pig

ratings = LOAD '/user/maria_dev/ml-100k/u.data' AS (userId:int,movieId:int,rating:int,ratingTime:int);

metadata = LOAD '/user/maria_dev/ml-100k/u.item' USING PigStorage('|') 
AS (movieId:int,movieTitle:chararray,releaseDate:chararray,videoRelease:chararray,imdbLink:chararray);

nameLookup = FOREACH metadata GENERATE movieId,movieTitle,ToUnixTime(ToDate(releaseDate,'dd-MMM-yyyy')) AS releaseTime;

ratingByMovie = Group ratings By movieId;

avgRatings = FOREACH ratingByMovie GENERATE group as movieId,AVG(ratings.rating) AS avgRating;

fiveStarMovies = FILTER avgRatings By avgRating > 4.0;

fiveStarWithData = JOIN fiveStarMovies By movieId,nameLookup By movieId;

mostPopularFiveStartMovies = ORDER fiveStarWithData By fiveStarMovies::avgRating DESC;

DUMP mostPopularFiveStartMovies;