創建一個文本文件`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;
```
