Apache Hive Online Quiz – Latest

Apache Hive Online Quiz

This Apache Hive Online Quiz will help you to revise your Hive concepts and check your Big Data knowledge. It will increase your confidence while appearing for Apache Hive interviews to land your dream Big Data jobs in India and abroad. Answers to all these Apache Hive Online Quiz Questions answers also provided along with them, it will help you to brush up your Knowledge.
If you are not familiar with Apache Hive, so you can refer our Apache Hive Tutorial. This will provide you the detailed description of Apache Hive and help you to solve this Apache Hive Online Quiz easily.
Also, you refer our Apache Hive Quiz Part-1 for Quiz.

Apache Hive Online Quiz

Apache Hive Online Quiz

So, ALL THE BEST!! For this Apache Hive Online Quiz.

Q.1 For optimizing join of three tables, the largest sized tables should be placed as

Correct! Wrong!

Q.2 Which of the following hint is used to optimize the join queries

Correct! Wrong!

Q.3 Calling a unix bash script inside a Hive Query is an example of

Correct! Wrong!

Q.4 Hive uses _________ for logging.

Correct! Wrong!

Q.5 HiveServer2 introduced in Hive 0.11 has a new CLI called

Correct! Wrong!

Q.6 In which mode HiveServer2 only accepts valid Thrift calls.

Correct! Wrong!

Q.7 Which of the following data type is supported by Hive?

Correct! Wrong!

Q.8 Which of the following is not a complex data type in Hive?

Correct! Wrong!

Q.9 Each database created in hive is stored as

Correct! Wrong!

Q.10 When a partition is archived in Hive it

Correct! Wrong!

Q.11 When a Hive query joins 3 tables, How many mapreduce jobs will be started?

Correct! Wrong!

Q.12 The reverse() function reverses a string passed to it in a Hive query. This is an example of

Correct! Wrong!

Q.13 Hive can be accessed remotely by using programs written in C++, Ruby etc, over a single port. This is achieved by using

Correct! Wrong!

Q.14 The thrift service component in hive is used for

Correct! Wrong!

Q.15 The query "SHOW DATABASE LIKE 'h.*' ; gives the output with database name

Correct! Wrong!

See also – 

Hive Quiz Part 3

Hive Quiz Part 4

4 Responses

  1. Ankur Jain says:

    Que 7. Which of the following data type is supported by Hive ?
    map
    record
    string
    enum
    As per my knowledge, the above question in hive quiz 2 is wrong. please check and update

    • Data Flair says:

      Hi Ankur
      Thanks for writing to us on “Apache HIve Online Quiz”. There is little typo mistake in the question no. 7, the correct question should be “Which of the following data types are not supported by Hive?” And for that correct answer will be the enum.
      Regards,
      Data-Flair

  2. rachana says:

    <3 it.
    but once check 3,8 qn's.some mistake is der.

    • Data Flair says:

      Hi Rachna,
      Thanks for attempting this “Apache Hive Quiz”, we are glad you like it. As of now, we couldn’t find any mistake still, we will check it once again, if any mistake found, we will update it soon.
      Hope you explore more Hive Quiz Questions from Data-Flair.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.