Hortonworks Exam Hadoop-PR000007 Topic 4 Question 73 Discussion

Actual exam question for Hortonworks's Hadoop-PR000007 exam

Question #: 73
Topic #: 4

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 Benton at Jul 04, 2024, 11:11 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

5 months ago

I think the answer is D) The statement is not a valid Hive command because INSERT OVERWRITE TABLE should be followed by a SELECT statement.

upvoted 0 times

...

6 months ago

Option B seems correct. The 'INSERT OVERWRITE' statement will replace the existing data in mytable with the contents of myothertable.

upvoted 0 times

5 months ago

B) Any existing data in mytable will be overwritten

upvoted 0 times

...

5 months ago

A) The contents of myothertable are appended to mytable

upvoted 0 times

...

6 months ago

I disagree, I believe the answer is C) A new table named mytable is created, and the contents of myothertable are copied into mytable.

upvoted 0 times

...

6 months ago

I think the answer is B) Any existing data in mytable will be overwritten.

upvoted 0 times

...