Hive 3.1.3.500 - 2401 (EEP 9.2.1) 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.500
Release Date January 2024
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.500-eep-921
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.300 - 2307:

  • 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.500 - 2401 introduces the following enhancements or HPE platform-specific behavior changes:
  • None.

Fixes

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

GitHub Commit Number Data (YYYY-MM-DD) HPE Fix Number and Description
9b11a6f146 2023-12-29 EEP-HIVE-1470: CTAS does not allow to create a table with custom location and with SELECT 1 as a data source
72e73d79b6 2023-12-22 EEP-HIVE-1469: hive.metastore.use.SSL property is broken in Hive-3.x
0f1ce9d023 2023-12-21 EEP-HIVE-1471: extract MapRKeystoreReader and related utils to a separate mapr-util module
93861f5d58 2023-12-19 EEP-HIVE-1467: hive.metastore.sasl.enabled property does not work in Hive-3.x
5b8efea891 2023-12-10 EEP-HIVE-1466: Compaction does not work for transactional tables in Hive-3.x.x
83a4aa71c8 2023-12-05 EEP-HIVE-1448: cksum: /opt/mapr/hive/hive-3.1.3/hcatalog/etc/webhcat/webhcat-site.xml: No such file or directory
70daa31ef8 2023-12-04 EEP-HIVE-1459: Update Avro to 1.11.3 due CVE-2023-39410
5dce82ac0c 2023-12-01 EEP-HIVE-1465: upgrade commons-io to 2.14.0
5447a9694a 2023-12-01 EEP-HIVE-1465: upgrade snappy-java to 1.1.10.5
0ec60aa06d 2023-12-01 EEP-HIVE-1465: upgrade ivy to 2.5.2
3c586a8e98 2023-12-01 EEP-HIVE-1465: upgrade netty to 4.1.101.Final
5fbed803f0 2023-12-01 EEP-HIVE-1465: upgrade jetty to 9.4.53.v20231009
d6c76784ee 2023-12-01 EEP-HIVE-1465: upgrade guava to 32.1.3-jre

Known Issues and Limitations

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