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

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

The first table in the join clause

Second table in the join clause

Third table in the join clause

Does not matter

Correct! Wrong!

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

/* joinlast(table_name) */

/* joinfirst(table_name) */

/* streamtable(table_name) */

/* cacheable(table_name) */

Correct! Wrong!

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

Hive Pipeline

Hive Caching

Hive Forking

Hive Streaming

Correct! Wrong!

Q.4 Hive uses _________ for logging.

logj4

log4l

log4i

log4j

Correct! Wrong!

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

BeeLine

SqlLine

HiveLine

CLilLine

Correct! Wrong!

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

Remote

HTTP

Embedded

Interactive

Correct! Wrong!

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

map

record

string

enum

Correct! Wrong!

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

Matrix

Array

Map

STRUCT

Correct! Wrong!

Q.9 Each database created in hive is stored as

A file

A directory

A HDFS block

A jar file

Correct! Wrong!

Q.10 When a partition is archived in Hive it

Reduces space through compression

Reduces the length of records

Reduces the number of files stored

Reduces the block size

Correct! Wrong!

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

0

1

2

3

Correct! Wrong!

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

Standard UDF

Aggregate UDF

Table Generating UDF

None of the above

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

HiveServer

HiveMetaStore

HiveWeb

Hive Streaming

Correct! Wrong!

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

Moving hive data files between different servers

Use multiple hive versions

Submit hive queries from a remote client

Installing hive

Correct! Wrong!

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

Containing h in their name

Starting with h

Ending with h

Containing 'h.'

Correct! Wrong!

See also – 

Hive Quiz Part 3

Hive Quiz Part 4