创建一个文本文件`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;
```
