...
| No Format |
|---|
CREATE TABLE u_data ( userid INT, movieid INT, rating INT, unixtime STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE; |
Then, download and extract unzip the data files from MovieLens 100k (see the GroupLens datasets page for a README.txt file and index of unzipped files):
| No Format |
|---|
wget http://www.grouplens.org/sites/www.grouplens.org/external_files/data/ml-data.tar.gz tar xvzf ml-data.tar.gz |
...