[TOC] ## insert 將查詢結果插入Hive表 語法結構 利用查詢語句，將查詢結果插入新的表 ~~~ INSERT OVERWRITE [INTO] TABLE tablename1 [PARTITION (partcol1=val1, partcol2=val2 ...)] select_statement1 FROM from_statement ~~~ 案例,覆蓋插入 ~~~ insert overwrite table t_1 partition(city='japan') select id,name,age from stu_partition; ~~~ 把數據插入本地 ~~~ insert overwrite local directory '/root/hivedata/data' select * from t_1; ~~~ 把數據插入hdfs ~~~ insert overwrite directory '/root/hivedata/data' select * from t_1; ~~~ 插入一條數據 ~~~ INSERT INTO TABLE VALUES(XX,YY,ZZ); ~~~ Multi Inserts多重插入: ~~~ FROM from_statement INSERT OVERWRITE TABLE tablename1 [PARTITION (partcol1=val1, partcol2=val2 ...)] select statement1 [INSERT OVERWRITE TABLE tablename2 [PARTITION ...] Select statement2] ... ~~~  Dynamic partition inserts動態分區插入: ~~~ INSERT OVERWRITE TABLE tablename PARTITION (partcol1[=val1], partcol2[=val2] ...) select_statement FROM from_statement ~~~ 使用了非嚴格模式 ~~~ set hive.exec.dynamic.partition.mode=nonstrict ~~~  這邊分區我們沒有指定,是查詢的時候,插入動態插入的