Why INSERT command in Hive

Question

Hi,

I am new to hive and getting confused with term INSERT OVERWRITE and INSERT INTO. How this two commands are different? Can anyone explain?

Answer 1

Hey,

The insert command is used to load the data Hive table. Inserts can be done to a table or a partition.

• INSERT OVERWRITE:- This command is used to overwrite the existing data in the table or partition.
• INSERT INTO:- This command is used to append the data into existing data in a table.