hive加载数据到表中

1.mkdir data

2.cd data

3.vim student.txt

1001   zhangshan

1002   lishi

1003   zhaoliu

(tab键间隔)

4.创建表

 create table student(id int, name string) ROW FORMAT DELIMITED FIELDS TERMINATED

 BY ' ';

5.load data local inpath '/data/student.txt'  into table student;

6.select * from student;

原文地址:https://www.cnblogs.com/yyfyl/p/15060153.html