1、建内部表
create table user (id int,name string,weight double) row format delimited fields terminated by '\t';
表名是user,有id,name,weight三个字段 . row format delimited fields terminated by '\t' 表示按照tab建做字段的分割符
标红的部分按照自己的业务修改
1.1 把数据导入user表
load data local inpath '/home/airib/work/hadoop/user.log' into table user;
从本地的/home/airib/work/hadoop/user.log文件吧数据导入到user 表。当然数据要以建表的的分割符作为字段的分割符
如果数据在hdfs上就不用加local 了 load data inpath '/home/airib/work/hadoop/user.log' into table user;
2、间外部表
create external table book (id int,name string) row format delimited fields terminated by '\t' location '/user/book';
表名book , 分隔符是tab ,location /user/book 表示你的数据在hdfs的/user/book下面
3、内部分区表
create table student(id int,name string) partitioned by (cls string) row format delimited fields terminated by '\t';
partitioned by (cls string) 表示按照cls字段分区
3.1分区表加数据
load data local inpath '/home/airib/work/hadoop/book' into table student partition (cls='class2');
4、外部分区表
create external table teacher (id int,name string) partitioned by (cls string) row format delimited fields terminated by '\t' location '/user/teacher'
partitioned by (cls string) 表示分区字段,location '/user/teacher' 表示外部文件的hdfs路径