Apache Hive Online Quiz – Latest

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

Which of the following hint is used to optimize the join queries

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

Hive uses _________ for logging.

HiveServer2 introduced in Hive 0.11 has a new CLI called

In which mode HiveServer2 only accepts valid Thrift calls.

Which of the following data type is supported by Hive?

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

Each database created in hive is stored as

When a partition is archived in Hive it

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

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

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

The thrift service component in hive is used for

The query “SHOW DATABASE LIKE ‘h.*’ ; gives the output with database name