hadoop学习笔记之HiveSQL DML

DML


load data [local] inpath 'filepath' [overwrite] into table tablename [partition (partcol1=val1, partcol2=val2...)]


insert overwrite table tablename1 [partition (partcol1=val1, partcol2=val2...) [if not exists] ] select_statement1 from from_statement;
insert into table tablename1 [partition (partcol1=val1, partcol2=val2 ...)] select_statement1 from from_statement;


from from_statement
insert overwrite table tablename1 [partition (partcol1=val1, partcol2=val2...) [if not exists]]
insert overwrite table tablename2 [partition ... [if not exists]] select_statement2]




动态分区
insert overwrite table tablename partition (partcol1, partcol2)
select xxx,p1,p2 from from_statement
要设置不严格模式




把表卸成文件
insert overwrite [local] directory directory1
[row format row_format] [stored as file_format] 
select ..from..