1 建表sample_data

create table sample_data
(sid int, sname string, gender string, language int, math int, english int)
row format delimited fields terminated by ',' stored as textfile;

2 数据/hadoop/hive/sample_data.txt

1,Tom,M,60,80,96
2,Mary,F,88,65,90
3,Jerry,M,90,85,88
4,Rose,M,79,85,90
5,Mike,F,90,88,94
6,John,F,85,80,80
7,Scott,F,70,90,80
8,King,F,90,88,75
9,Kitty,M,88,77,95
10,James,M,77,80,94

3 导入数据

load data local inpath '/hadoop/hive/sample_data.txt' into table sample_data;