Q. _________ is a shell utility which can be used to run Hive queries in either interactive or batch mode.

View solution

Q. Which of the following is a command line option?

View solution

Q. Which is the additional command line option is available in Hive 0.10.0?

View solution

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