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

Q. _______ is a lossless data compression library that favors speed over compression ratio.

View solution

Q. Which of the following will prefix the query string with parameters?

View solution

Q. Integral literals are assumed to be _________ by default.

View solution

Q. Hive uses _____ style escaping within the strings.

View solution

Q. Which of the following statement will create a column with varchar datatype?

View solution

Q. _________ will overwrite any existing data in the table or partition.

View solution

Q. Hive does not support literals for ______ types.

View solution