使用insert子句将查询结果插入到hive表

使用insert子句将查询结果插入到hive表

语法

标准语法:

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;

resource:http://www.superwu.cn/2015/06/16/2893/