Hive 3.1.3.900 (DEP 10.0.1) Release Notes

Feature support

The following list describes support of various components and functionality with Hive 3.1.3.750 or higher:

• Supports Hive-3.1.3 on Tez-0.10.2.

• Does not support Hive on Spark, so you cannot use Spark as an execution 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

• Starting from Hive 2.1, Hive needs to run the schematool command as an initialization step.

New in This Release

None

Fixes

This release includes CVE and bug fixes according to the following list of changes.

For complete details refer to the commit log for this project in GitHub.

Known Issues and Limitations

• Hive SchemaTool fails with type clob does not exist error during lower environment upgrade, when the backend database is PostgreSQL. To resolve the issue, do the steps that follow:
  1. In upgrade-3.0.0-to-3.1.0.postgres.sql, change the code as follows:

     • From:

       -- HIVE-23683
       ALTER TABLE "COMPACTION_QUEUE" ADD "CQ_ENQUEUE_TIME" bigint;
       ALTER TABLE "COMPLETED_COMPACTIONS" ADD "CC_ENQUEUE_TIME" bigint;

       To:

       -- HIVE-23683
       ALTER TABLE COMPACTION_QUEUE ADD CQ_ENQUEUE_TIME bigint;
       ALTER TABLE COMPLETED_COMPACTIONS ADD CC_ENQUEUE_TIME bigint;

     • From:

       -- HIVE-22729
       ALTER TABLE COMPACTION_QUEUE ADD CQ_ERROR_MESSAGE clob;
       ALTER TABLE COMPLETED_COMPACTIONS ADD CC_ERROR_MESSAGE clob;

       To:

       -- HIVE-22729
       ALTER TABLE COMPACTION_QUEUE ADD CQ_ERROR_MESSAGE text;
       ALTER TABLE COMPLETED_COMPACTIONS ADD CC_ERROR_MESSAGE text;

  2. Restart the Hive services.
• See Considerations for Hive on JDK 17 and later.