Hive Quiz 3

Hadoop MCQ  Set 

Enter your email address:


Delivered by FeedBurner

Hi One and all welcome to hive practice session ..
add your mail Id in Comment and score so we can help you directional working, learn hive and be a expert.

Hivequiz blog will be publishing more quiz set related to hive and other Bigdata technologies

Hive 2:

1. The default delimiter in hive to separate the element in STRUCT is '\001'
'\002'
'\003'
'\004'
2. in hive when the schema does not match the file content It cannot read the file
It reads only the string data type
It returns null values for mismatched fields.
it throws an error and stops reading the file
3. The query "SHOW DATABASE LIKE 'h.*' ; gives the output with database name containing 'h.'
containing h in their name
ending with h
starting with h
4. The tables created in hive are stored as a subdirectory under the database directory
a .java file present in the database directory
a hdfs block containing the database directory
a file under the database directory
5. An element in a STRUCT column in hive is referred by index
key
colon
dot
6. The performance of an aggregate query is improved by setting which of the following property as true?
hive.map.group
hive.map.aggr
hive.map.sort
hive.map.sum
7. The CONCAT string function in Hive can concatenate only 2 strings
any number of strings
only strings of equal length
any number of paired strings
8. The clause used to limit the number of rows returned by a query is MAXROW
RESTRICT
ROWNUM
LIMIT
Score =
Correct answers: