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

Q. The files that are written by the _______ job are valid Avro files.

View solution

Q. Use ________ and embed the schema in the create statement.

View solution

Q. _______ is interpolated into the quotes to correctly handle spaces within the schema.

View solution

Q. To force Hive to be more verbose, it can be started with ___________

View solution

Q. ________ was designed to overcome limitations of the other Hive file formats.

View solution

Q. An ORC file contains groups of row data called __________

View solution

Q. Serialization of string columns uses a ________ to form unique column values.

View solution