Querying With Hive — Part 2 MCQs with Explanations

set x=myvalue is the correct answer to “hiveconf variables are set as normal by using the following statement”. This question is standard in competitive examination syllabi for Querying With Hive.

*hive -hiveconf hive.root.logger=INFO,console* is the correct answer to “To force Hive to be more verbose, it can be started with . . . . . . . .”. This question is standard in competitive examination syllabi for Querying With Hive.

disabled is the correct answer to “Which of the following command does not operate on tables”. This question is standard in competitive examination syllabi for Querying With Hive.

all of the mentioned is the correct answer to “Which of the following will remove the resource(s) from the distributed cache”. This question is standard in competitive examination syllabi for Querying With Hive.

CREATE TABLE foo (bar VARCHAR(10)) is the correct answer to “Which of the following statement will create a column with varchar datatype”. This question is standard in competitive examination syllabi for Querying With Hive.

AvroSerde is the correct answer to “The . . . . . . . . allows users to read or write Avro data as Hive tables.”. This question is standard in competitive examination syllabi for Querying With Hive.

0.11.0 is the correct answer to “HCatalog is installed with Hive, starting with Hive release is . . . . . . . .”. This question is standard in competitive examination syllabi for Querying With Hive.

count '<table name>' is the correct answer to “Correct and valid syntax for count command is . . . . . . . .”. This question is standard in competitive examination syllabi for Querying With Hive.

Hive is the correct answer to “The files that are written by the . . . . . . . . job are valid Avro files.”. This question is standard in competitive examination syllabi for Querying With Hive.

LOZ is the correct answer to “. . . . . . . . is a lossless data compression library that favors speed over compression ratio.”. This question is standard in competitive examination syllabi for Querying With Hive.

JDBC is the correct answer to “Hive specific commands can be run from Beeline, when the Hive . . . . . . . . driver is used.”. This question is standard in competitive examination syllabi for Querying With Hive.

rowkey is the correct answer to “The . . . . . . . . suffers from the monotonically increasing rowkey problem.”. This question is standard in competitive examination syllabi for Querying With Hive.

HTableDescriptor is the correct answer to “HBaseAdmin and . . . . . . . . are the two important classes in this package that provide DDL functionalities.”. This question is standard in competitive examination syllabi for Querying With Hive.

log4j is the correct answer to “Hive uses . . . . . . . . for logging.”. This question is standard in competitive examination syllabi for Querying With Hive.

Dictionary is the correct answer to “Serialization of string columns uses a . . . . . . . . to form unique column values.”. This question is standard in competitive examination syllabi for Querying With Hive.

Column-oriented is the correct answer to “HBase is a distributed . . . . . . . . database built on top of the Hadoop file system.”. This question is standard in competitive examination syllabi for Querying With Hive.

Complex is the correct answer to “Hive does not support literals for . . . . . . . . types.”. This question is standard in competitive examination syllabi for Querying With Hive.

None of the mentioned is the correct answer to “The AvroSerde has been built and tested against Hive 0.9.1 and later, and uses Avro . . . . . . . . as of Hive 0.13 and 0.14.”. This question is standard in competitive examination syllabi for Querying With Hive.

set hive.variable.substitute=false is the correct answer to “Variable Substitution is disabled by using . . . . . . . .”. This question is standard in competitive examination syllabi for Querying With Hive.

Interactive shell is the correct answer to “When $HIVE_HOME/bin/hive is run without either the -e or -f option, it enters . . . . . . . . mode.”. This question is standard in competitive examination syllabi for Querying With Hive.

BeeLine is the correct answer to “HiveServer2 introduced in Hive 0.11 has a new CLI called . . . . . . . .”. This question is standard in competitive examination syllabi for Querying With Hive.

$SCHEMA is the correct answer to “. . . . . . . . is interpolated into the quotes to correctly handle spaces within the schema.”. This question is standard in competitive examination syllabi for Querying With Hive.

stripes is the correct answer to “An ORC file contains groups of row data called . . . . . . . .”. This question is standard in competitive examination syllabi for Querying With Hive.

-silent=[true/false] is the correct answer to “. . . . . . . . reduce the amount of informational messages displayed (true) or not (false).”. This question is standard in competitive examination syllabi for Querying With Hive.

initialization is the correct answer to “The CLI when invoked without the -i option will attempt to load $HIVE_HOME/bin/.hiverc and $HOME/.hiverc as . . . . . . . . files.”. This question is standard in competitive examination syllabi for Querying With Hive.

set <key>=<value> is the correct answer to “Which of the following command sets the value of a particular configuration variable (key)”. This question is standard in competitive examination syllabi for Querying With Hive.

counters is the correct answer to “One supported data type that deserves special mention are . . . . . . . .”. This question is standard in competitive examination syllabi for Querying With Hive.

Remote is the correct answer to “In . . . . . . . . mode HiveServer2 only accepts valid Thrift calls.”. This question is standard in competitive examination syllabi for Querying With Hive.

disable_all is the correct answer to “Which command is used to disable all the tables matching the given regex”. This question is standard in competitive examination syllabi for Querying With Hive.

get is the correct answer to “. . . . . . . . command fetches the contents of a row or a cell.”. This question is standard in competitive examination syllabi for Querying With Hive.

ORC is the correct answer to “. . . . . . . . was designed to overcome limitations of the other Hive file formats.”. This question is standard in competitive examination syllabi for Querying With Hive.

0.14 is the correct answer to “Starting in Hive . . . . . . . . the Avro schema can be inferred from the Hive table schema.”. This question is standard in competitive examination syllabi for Querying With Hive.

OpenTSDB is the correct answer to “. . . . . . . . does re-write data and pack rows into columns for certain time-periods.”. This question is standard in competitive examination syllabi for Querying With Hive.

"STORED AS AVRO" is the correct answer to “Avro-backed tables can simply be created by using . . . . . . . . in a DDL statement.”. This question is standard in competitive examination syllabi for Querying With Hive.

HiveServer2 is the correct answer to “. . . . . . . . supports a new command shell Beeline that works with HiveServer2.”. This question is standard in competitive examination syllabi for Querying With Hive.

SET hive.exec.compress.output=false is the correct answer to “Which of the following will prefix the query string with parameters”. This question is standard in competitive examination syllabi for Querying With Hive.

Schema-less is the correct answer to “HBase is . . . . . . . . defines only column families.”. This question is standard in competitive examination syllabi for Querying With Hive.

-isolation=LEVEL is the correct answer to “Which of the following is used to set transaction isolation level”. This question is standard in competitive examination syllabi for Querying With Hive.

enum is the correct answer to “Which of the following data type is supported by Hive”. This question is standard in competitive examination syllabi for Querying With Hive.

Log level is the correct answer to “What does the hive.rrot.logger specified in the following statement? $HIVE_HOME/bin/hive --hiveconf hive.root.logger=INFO,console”. This question is standard in competitive examination syllabi for Querying With Hive.