Q. The CLI when invoked without the -i option will attempt to load $HIVE_HOME/bin/.hiverc and $HOME/.hiverc as _______ files.

View solution

Q. When $HIVE_HOME/bin/hive is run without either the -e or -f option, it enters _______ mode.

View solution

Q. Hive uses _________ for logging.

View solution

Q. What does the hive.rrot.logger specified in the following statement?

$HIVE_HOME/bin/hive --hiveconf hive.root.logger=INFO,console

View solution

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

View solution

Q. HCatalog is installed with Hive, starting with Hive release is ___________

View solution

Q. hiveconf variables are set as normal by using the following statement?

View solution

Q. Variable Substitution is disabled by using ___________

View solution

Q. _______ supports a new command shell Beeline that works with HiveServer2.

View solution

Q. In ______ mode HiveServer2 only accepts valid Thrift calls.

View solution

Q. Hive specific commands can be run from Beeline, when the Hive _______ driver is used.

View solution

Q. _________ reduce the amount of informational messages displayed (true) or not (false).

View solution

Q. Which of the following is used to set transaction isolation level?

View solution

Q. The ________ allows users to read or write Avro data as Hive tables.

View solution

Q. Starting in Hive _______ the Avro schema can be inferred from the Hive table schema.

View solution

Q. 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.

View solution

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

View solution

Q. Which of the following data type is converted to Array prior to Hive 0.12.0?

View solution

Q. Avro-backed tables can simply be created by using _________ in a DDL statement.

View solution

Q. Types that may be null must be defined as a ______ of that type and Null within Avro.

View solution