![]() LEFT OUTER JOIN u.item ON (udata.movieid=uitem. ![]() 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 HIVE is a searing drama based on the true story of Fahrije (Yllka Gashi), who, like many of the other women in her patriarchal village, has lived with. # 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) ![]() Row format delimited fields terminated by '|' User_id int, movie_id int, rating int, timestamp bigint) Hadoop fs -put movies/u.item /user/movies Hadoop fs -put movies/u.data /user/movies ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |