DROP TABLE IF EXISTS movieRatings;

CREATE TABLE movieRatings (

userId INT,

movieId INT,

rating FLOAT,

timeRecorded INT

) USING csv OPTIONS (

PATH “/mnt/training/movies/20m/ratings.csv”,

header “true”

);