Which one of the following statements is true?

Given the following Hive command:

INSERT OVERWRITE TABLE mytable SELECT * FROM myothertable;

Which one of the following statements is true?
A . The contents of myothertable are appended to mytable
B . Any existing data in mytable will be overwritten
C . A new table named mytable is created, and the contents of myothertable are copied into mytable
D . The statement is not a valid Hive command

View Answer

Answer: B