1.load data
//[local]:数据文件在linux本地,则要加local;在HDFS上,就不用加
//[overwrite]: 覆盖数据
//[partition]:指定分区,即指定分存在哪个区目录下
load data [local] inpath 'filepath'
[overwrite] into table tablename
[partition (partColumn1=val1,partColumn2=val2)]
2.insert
create table table1 like table2;
insert into table1 select * from table3;
3.location
create table table1
...
location '/user/t.txt'