You can execute the INSERT OVERWRITE INTO SELECT
statement to insert multiple records to a table at a time.
Syntax
INSERT OVERWRITE INTO table_name [(column_name,...)]
SELECT select_statement FROM from_statement
Precautions
- The destination table must exist to execute the
INSERT OVERWRITE INTO SELECT
statement to insert records. - The original data in the destination table does not change until the
INSERT OVERWRITE INTO SELECT
statement is complete. After theINSERT OVERWRITE INTO SELECT
statement is complete, the system writes inserted data to the destination table and clears the original data. TheINSERT OVERWRITE INTO SELECT
statement is used to import large amounts of data. We recommend that you do not use it to import small amounts of data. - The
INSERT OVERWRITE INTO SELECT
statement can be used to insert a specific column. Other columns are set to their default value. If no default value is specified, NULL is specified. - When you write data to a table, you cannot use the
INSERT OVERWRITE INTO SELECT
statement in combination with the INSERT INTO, REPLACE INTO, DELETE, or UPDATE statement. Otherwise, data written in real time is discarded. For more information, see INSERT INTO, REPLACE INTO, DELETE, and UPDATE.