SELECT AVG(a.rating) as rating, b.movie_title #Find the highest average rated sci_fi movie. #List the titles of the movies with the 10 most ratings. # List the movieid of the 10 films that recieved the most ratings. SELECT movieid, movie_title, substr(relase_date, 8, 4) # Find the names of all movies released in 1990 # How many records are in the u.data and u.item tables? # Display first few lines to ensure data were loaded correctly Movie_id int, movie_title string, release_date string, video_release_date string, imbd_url string, unknown string, action int, adventure int, animation int, childrens int, comedy int, crime int, documentary int, drama int, fil_noir int, horror int, muscial int, mystery int, romance int, sci_fi int, thriller int, war int, western int) From all the excellent new study facilities at the University I especially like The Hive - a fantastic big library where you can find all the books that. Row format delimited fields terminated by '|' And everything to keep the kids entertained with a.
ALL MY MOVIES HIVE MOVIE
User_id int, movie_id int, rating int, timestamp bigint) Weve got the most popular DVDs from the newest to those cult movie archives and favourite comedy classics. Hadoop fs -put movies/u.item /user/movies Welcome to the sixth episode of the Movies & TV Shows Community podcast.
Hadoop fs -put movies/u.data /user/movies