Hive 3.1.3.100 - 2301 (EEP 9.1.0) Release Notes

The following notes relate specifically to the HPE Ezmeral Data Fabric Distribution for Apache Hive. You may also be interested in the Apache Hive-3.1.3 Release Notes and the Apache Hive homepage.

Hive Version	3.1.3.100
Release Date	January 2023
HPE Version Interoperability	See Hive and HCatalog Support Matrix and Ecosystem Support Matrix and EEP Components and OS Support.
Source on GitHub	https://github.com/mapr/hive
GitHub Release Tag	3.1.3.100-eep-910
Maven Artifacts	https://repository.mapr.com/maven/
Package Names	Navigate to http://package.ezmeral.hpe.com/releases/MEP/, and select your EEP(MEP) and OS to view the list of package names.
ODBC/JDBC Drivers	Hive 3.1.3 works with the following HPE Hive drivers: ODBC Drivers Mac OS X Linux 32-bit 64-bit Windows 32-bit 64-bit For additional driver information, see Connecting to HiveServer2.

Feature support

The following list describes support of various components and functionality with Hive 3.1.3.100 - 2301:

Supports Hive-3.1.3 on Tez-0.10.2 For more information, see Tez 0.10.2.100 - 2301 (EEP 9.1.0) Release Notes.
Does not support Hive on Spark. You cannot use Spark as a query engine for Hive. However, you can run Hive and Spark on the same cluster. You can also use Spark SQL and Drill to query Hive tables.
Does not support HDFS encryption in Hive tables.
Does not support LLAP with Hive-3.1.3 because Apache Slider is not an HPE supported ecosystem component.
Starting from Hive 2.1, Hive must run the schematool command as an initialization step.
Starting from EEP 9.1.0, you can enable Hive to work with JDK 17. See Considerations for JDK 17.
Starting from EEP 9.0.0, Data Fabric supports Ranger, which can be integrated with HiveServer2. For more information, see Integrating HiveServer2 with Ranger.

Hive 3.1.3.100 - 2301 introduces the following enhancements or HPE platform-specific behavior changes:

This HPE release includes the following fixes on the base release:

GitHub Commit Number	Data (YYYY-MM-DD)	HPE Fix Number and Description
be3f282f11	2023-01-03	EEP-HIVE-1349: Update Hive in EEP 9.1.0 to Antlr Runtime version 4.9.3
4784937501	2022-12-22	EEP-HIVE-1344: Update Hive OJAI dep to v3.2.0
ec6f0122fc	2022-12-07	EEP-HIVE-1340: Update protobuf-java version to 3.21.9
ab53ad8d96	2022-10-14	EEP-HIVE-1318 : Remove Expiry check on ticket when using MapR-SASL
04c1ec16be	2022-10-09	EEP-HIVE-1327 : CVE-2022-36364 vulnerability in Calcite Avatica

HIVE-1315: Hive 3 on Tez 0.10.x is unable to run jobs by using S3 endpoint in HPE Ezmeral Data Fabric Object Store. There is no workaround for this issue in this release.
HIVE-19502: Unable to insert values into table stored by JdbcStorageHandler
HIVE-19286: NPE in MERGE operator on MR mode
HIVE-1336: When using Hive configured with Java 17, sometimes, Hive gives the following error:
```
Caused by: java.lang.reflect.InaccessibleObjectException: <detailed description>: module java.base does not "opens <module name>" to unnamed module
```
Error example:
```
Caused by: java.lang.reflect.InaccessibleObjectException: Unable to make field private final int java.time.LocalDate.year accessible: module java.base does not "opens java.time" to unnamed module
```
Workaround:
Add the --add-opens java.base/<module name>=ALL-UNNAMED configuration option (for example, --add-opens java.base/java.time=ALL-UNNAMED) to the following:
1. HADOOP_OPTS variable in the hive-env.sh configuration file.
2. mapreduce.map.java.opts, mapreduce.reduce.java.opts, yarn.app.mapreduce.am.command-opts properties of the hive-site.xml configuration file.