Hortonworks Exam Hadoop-PR000007 Topic 4 Question 75 Discussion

Actual exam question for Hortonworks's Hadoop-PR000007 exam

Question #: 75
Topic #: 4

Assuming the following Hive query executes successfully:

Which one of the following statements describes the result set?

AA bigram of the top 80 sentences that contain the substring 'you are' in the lines column of the input data A1 table.

BAn 80-value ngram of sentences that contain the words 'you' or 'are' in the lines column of the inputdata table.

CA trigram of the top 80 sentences that contain 'you are' followed by a null space in the lines column of the inputdata table.

DA frequency distribution of the top 80 words that follow the subsequence 'you are' in the lines column of the inputdata table.

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

8 months ago

That makes sense, I see your point

upvoted 0 times

...

8 months ago

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

upvoted 0 times

...

9 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

9 months ago

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

upvoted 0 times

...

9 months ago

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

upvoted 0 times

...

9 months ago

I think the answer is B)

upvoted 0 times

...