Hive 3.1.3.100 - 2301 (EEP 9.1.0) Release Notes

The following notes relate specifically to the HPE 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 Ecosystem Pack 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:

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.

  • 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.

New in This Release

Hive 3.1.3.100 - 2301 introduces the following enhancements or HPE platform-specific behavior changes:
  • CVEs fixes
  • Bug fixes

Fixes

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

Known Issues and Limitations

  • HIVE-1315: Hive 3 on Tez 0.10.x is unable to run jobs by using S3 endpoint in HPE 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.