Hortonworks Exam Hadoop-PR000007 Topic 4 Question 73 Discussion

Actual exam question for Hortonworks's Hadoop-PR000007 exam

Question #: 73
Topic #: 4

[All Hadoop-PR000007 Questions]

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

Get Premium Hadoop-PR000007 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Zona

11 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

...

Jacklyn

11 months ago

Option C is a bit misleading. The statement doesn't create a new table, it just overwrites the existing one. What a tricky question!

upvoted 0 times

Natalie

11 months ago

B) Any existing data in mytable will be overwritten

upvoted 0 times

...

Jenise

11 months ago

A) The contents of myothertable are appended to mytable

upvoted 0 times

...

Han

11 months ago

But wouldn't that mean the existing data in mytable will be preserved?

upvoted 0 times

...

Patti

12 months ago

Haha, option D is pretty funny. Who would even think that's a valid Hive command? I mean, really?

upvoted 0 times

...

Major

12 months ago

I agree with Allene. This is a common Hive command used to update a table with new data, overwriting the existing contents.

upvoted 0 times

...

Allene

12 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

Elina

11 months ago

B) Any existing data in mytable will be overwritten

upvoted 0 times

...

Dante

11 months ago

A) The contents of myothertable are appended to mytable

upvoted 0 times

...

Levi

12 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

...

Han

1 years ago

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

upvoted 0 times

...