Question

_________ will overwrite any existing data in the table or partition.

(a) INSERT WRITE

(b) INSERT OVERWRITE

(c) INSERT INTO

(d) None of the mentioned

This question was addressed to me during an interview.

I need to ask this question from Querying Data with HiveQL topic in section Hive and HBase of Hadoop

Answer 1

Right answer is (c) INSERT INTO

To elaborate: INSERT INTO will append to the table or partition, keeping the existing data intact.