Hortonworks Exam Hadoop-PR000007 Topic 3 Question 69 Discussion

Actual exam question for Hortonworks's Hadoop-PR000007 exam

Question #: 69
Topic #: 3

Given the following Hive command:

INSERT OVERWRITE TABLE mytable SELECT * FROM myothertable;

Which one of the following statements is true?

AThe contents of myothertable are appended to mytable

BAny existing data in mytable will be overwritten

CA new table named mytable is created, and the contents of myothertable are copied into mytable

DThe statement is not a valid Hive command

Show Suggested Answer

Suggested Answer: B

by Graciela at May 13, 2024, 01:52 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!