Following quiz provides Multiple Choice Questions (MCQs) related to Hive. You will have to read all the given answers and click over the correct answer. If you are not sure about the answer then you can check the answer using Show Answer button. You can use Next Quiz button to check new set of questions in the quiz.
Q 1 - The thrift service component in hive is used for
Client machines can use programing languages like Java, Ruby etc to access Hive remotely using Hive Thrift service.
Q 2 - The drawback of managed tables in hive is
As they are managed by Hive metadata, other applications cannot access it.
Q 3 - To see the data types details of only a column (not the table) we should use the command
Q 4 - When the result of the STRING data type is returned by querying array data type using index, the result have
The STRINGS returned form ARRAYS will not contain the quotes.
Q 5 - The below expression in the where clause
gives the result which match
Hive supports java based regular expression for querying.
Q 6 - what can be altered about a view
TBLPROPERTIES stores some documentation about the table like created date time etc.
Q 7 - The identifiers in HiveQL are
Hive is case insensitive
Q 8 - Which of the following hint is used to optimize the join queries
Streaming a table of small size makes the query faster.
Q 9 - The reverse() function reverses a string passed to it in a Hive query. This is an example of
reverse(‘abcd’) gives ‘dcba’. So it is a standard UDF.
Q 10 - When one of the join tables is small enough to fit into memory, The type of join used by Hive is
As one of the tables already fits into the memory each row of the big table is quickly compared with each row of small table using Map Join.