创建一个文本文件`1.txt` ``` 1,Apollo,25 2,Paul,43 3,Tom,55 4,Marry,29 ``` 创建一个表映射 ```mysql create table t_t2(id int, name string, age int) row format delimited fields terminated by ','; ``` 将文本文件`1.txt`上传到`/user/hive/warehouse/gosuncn.db/t_t2`目录中 ```bash hadoop fs -put 1.txt /user/hive/warehouse/gosuncn.db/t_t2 ``` 接下来可以进行 ```mysql select * from t_t2; select count(*) from t_t2; ```