Hortonworks Exam Hadoop-PR000007 Topic 4 Question 75 Discussion

Actual exam question for Hortonworks's Hadoop-PR000007 exam

Question #: 75
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 Iluminada at Jul 14, 2024, 10:52 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

6 months ago

That makes sense, I see your point

upvoted 0 times

...

6 months ago

D, obviously. Hive commands are written in Elvish, and this one is clearly just gibberish.

upvoted 0 times

...

6 months ago

Wait, so does this mean I can just dump all my data into a table and call it a day? Sounds like a good plan to me!

upvoted 0 times

6 months ago

So, it doesn't just append the data? Good to know, thanks for the heads up.

upvoted 0 times

...

6 months ago

No, you have to be careful with that command. It overwrites existing data in the table.

upvoted 0 times

...

7 months ago

I think the answer is B)

upvoted 0 times

...