load data inpath '/user/tom/data01.txt' into table external_table;
读取本地文件数据到外部表中
load data local inpath '/home/hadoop/data02.txt' into table external_table
load data local inpath '/home/hadoop/data02.txt' overwrite into table external_table
分区表
创建分区表
create table partition_table (id int, name string, city string)
partitioned by (pt string)
row format delimited fields terminated by '\t';
读取本地文件数据到分区表中
load data local inpath 'data02.txt' overwrite into table partition_table partition(pt='02')
查询分区的方法
show partitions 表名;
修改分区的名称
alter table 表名 partition(partition_column=value)
rename to partition(partition_column=value)
增加表字段
alter table user add columns
(address string,
tel string,
qq string,
birthday date);
修改表的字段(名字以及数据类型)
alter table user change address addr int;
查询结果添加到新表
create table login2(uid string);
insert into overwrite table login2 select id from partition_table;
查询结果输出到文件系统中
from login
insert overwrite local directory '/home/hadoop/login'select*
insert overwrite directory '/tmp/ip'select ip;