使用insert子句将查询结果插入到hive表，inserthive
使用insert子句将查询结果插入到hive表，inserthive
使用insert子句将查询结果插入到hive表（Inserting
data into Hive Tables fromqueriesQuery Results can be inserted into tablesby using the insert clause）
语法
标准语法:
INSERT OVERWRITETABLE tablename1 [PARTITION (partcol1=val1, partcol2=val2 ...)]select_statement1 FROM from_statement;
INSERT INTO TABLEtablename1 [PARTITION (partcol1=val1, partcol2=val2 ...)] select_statement1FROM from_statement;
Hive 扩展 (多条插入multipleinserts):
FROM from_statement
INSERT OVERWRITETABLE tablename1 [PARTITION (partcol1=val1, partcol2=val2 ...)]select_statement1
[INSERT OVERWRITETABLE tablename2 [PARTITION ...] select_statement2]
[INSERT INTO TABLEtablename2 [PARTITION ...] select_statement2] ...;
FROM from_statement
INSERT INTO TABLEtablename1 [PARTITION (partcol1=val1, partcol2=val2 ...)] select_statement1
[INSERT INTO TABLEtablename2 [PARTITION ...] select_statement2]
[INSERT OVERWRITETABLE tablename2 [PARTITION ...] select_statement2] ...;
Hive extension (dynamicpartition inserts):
INSERT OVERWRITETABLE tablename PARTITION (partcol1[=val1], partcol2[=val2] ...)select_statement FROM from_statement;
INSERT INTO TABLEtablename PARTITION (partcol1[=val1], partcol2[=val2] ...) select_statementFROM from_statement;
更多精彩内容请关注：http://bbs.superwu.cn
关注超人学院微信二维码：
|
评论暂时关闭