hive 建表，建外部表，建分区表

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路径