fly6516
2912a4f86a
- 新增 App.java 和 AppTest.java 文件作为项目示例 - 添加 command.md、origin.md 和 sql.md 文件，包含项目相关命令和 SQL 语句 - 创建 pom.xml 文件定义项目依赖
788 B
DROP TABLE IF EXISTS ratings; DROP TABLE IF EXISTS movies; DROP TABLE IF EXISTS users;
CREATE EXTERNAL TABLE users ( UserID BIGINT, Gender STRING, Age INT, Occupation STRING, Zipcode STRING ) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE LOCATION '/user/hadoop/movie_data/users';
CREATE EXTERNAL TABLE movies ( MovieID BIGINT, Title STRING, Genres STRING ) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE LOCATION '/user/hadoop/movie_data/movies';
CREATE EXTERNAL TABLE ratings ( UserID BIGINT, MovieID BIGINT, Rating DOUBLE, Timestamped STRING ) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE LOCATION '/user/hadoop/movie_data/ratings';
SELECT * FROM users LIMIT 5; SELECT * FROM movies LIMIT 5; SELECT * FROM ratings LIMIT 5;