Supported and Unsupported Features in Hive 3.1.1 (beta)

Before using Hive 3.1.1 (beta), learn more about the prerequisites and features that it only supports, and does not support from these sections:


These are the prerequisites to configure Hive 3.1.1 (beta):

  • JAVA 8 : Hive 3.1.1 does not work with JAVA 7, so, you must use JAVA 8.

  • Metastore Database version as 3.1.0. To upgrade:

    • Qubole-managed Metastore: Contact Qubole Support to upgrade the metastore database.

    • Custom Managed Metastore: To upgrade custom-managed metastore, use metastore upgrade scripts from Hive [3.1.2 release version] as Hive 3.1.2 version has backward compatibility related fixes.

Supported Features Only in Hive 3.1.1 (beta)

These are the features that Hive 3.1.1 (beta) supports:

  • Running Hive queries only on HiveServer2

  • Hadoop 3 and not Hadoop 2. Configuring Hive 3.1.1 intrinsically selects Hadoop 3.

  • Tez 0.9.1. Configuring Hive 3.1.1 intrinsically selects Tez 0.9.1.

  • ACID transactions

Unsupported Features in Hive 3.1.1 (beta)

Hive 3.1.1 (beta) does not support:

  • Table copy

  • Qubole Tmp Tables

  • AWS Glue

  • OpenX JSON SerDe

  • MapReduce

  • Running Hive queries on the coordinator node

  • Running Hive queries on QDS servers