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:
Prerequisites
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