Hive 2.1.1-1710 Release Notes

This section provides reference information, including new features, fixes, known issues, and limitations for Hive 2.1-1710.

Below are release notes for the Hive component included in the MapR Converged Data Platform. You may also be interested in the Apache Hive 2.1.1 Release Notes or the Apache Hive homepage.

Hive Version 2.1
Release Date November 2017
MapR Version Interoperability See Hive and HCatalog Support Matrix and Ecosystem Support Matrix (Pre-5.2 releases) and EEP Components and OS Support.
Source on GitHub https://github.com/mapr/hive/tree/2.1.1-mapr-1710
Maven Artifacts See Maven Artifacts for MapR.
Package Names Navigate to https://package.ezmeral.hpe.com/releases/MEP/, and select your EEP and OS to view the list of package names.

Feature Support

  • MapR supports Hive-2.1.1 on Tez-0.8.4.
  • MapR does not support Hive on Spark. Therefore, 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.
  • MapR does not support HDFS encryption in Hive tables.
  • MapR does not support Hbase-0.9X with Hive-2.1.1. Only Hbase-1.X is compatible with Hive-2.1.1.
  • MapR does not support LLAP with Hive-2.1.1 since Apache Slider is not in MapR ecosystem.
  • Starting from Hive 2.1, Hive needs to run the schematool command as an initialization step.

New Features

  • Includes Hive support for MapR Database JSON tables.
  • Includes MapR-SASL as default security for HiveServer 2 and Hive Metastore on secure cluster.

Fixes

This release by MapR includes the following fixes on the base Apache release. For complete details, refer to the commit log for this project in GitHub.

Commit Date (YYYY-MM-DD) Comment
7ea39f4 2017-10-25 MAPR-HIVE-104: The issue that caused TableClosedException when performing an operation on a closed table is now fixed.
ace4158 2017-09-19 MAPR-HIVE-70: The issue that caused TableClosedException when performing an operation on a closed table is now fixed.
e7314ca 2017-09-12 MAPR-29056: The issue that caused an exception when inserting data into table on AWS is now fixed.
2b313da 2017-09-11 MAPR-HIVE-21: Hive now includes support for MapR Database JSON tables from Hive. For more information, see Connecting Using Hive MapR Database JSON Connector.
f8f543c 2017-09-05 MAPR-28898: The issue that caused 'multiple SLF4J bindings' warnings is now fixed.
59ef497 2017-05-30 MAPR-HIVE-3: Hive is now secured by default. For more information, see Hive Security.
d7f2dd1 2017-08-29 MAPR-HIVE-41: The issue that caused warnings on CentOS when trying to uninstall already removed Hbase JARs is now fixed.
6adf28d 2017-08-28 MAPR-28881: The hive-site.xml file now contains only needed properties because all unnecessary properties have been removed.
0133468 2017-07-21 MAPR-HIVE-42: The issue that caused HiveServer2 to not stop, but continue running when the cluster was shutdown (from the UI) is now fixed.
8a01d62 2017-08-24 MAPR-27403: Hive now uses Joda-time version 2.9.9 because some functionality were breaking in Joda-time version below 2.8.0.
0cca11a 2017-08-14 MAPR-28428: The issue that caused incorrect result for Hive join query with COALESCE in WHERE condition is now fixed.

This release by MapR also includes the following backported issues. For complete details, refer to the commit log for this project in GitHub.

Commit Date (YYYY-MM-DD) Comment
2753757 2017-04-19 HIVE-16473: The issue that caused Hive-on-Tez to fail to write to an HBase table is now fixed.
60a5918 2017-09-26 HIVE-10378: The issue that caused Hive Update statement set keyword to work with lower case and not uppercase is now fixed. If incorrect column name is specified in the set clause, a warning is now returned.
51ed0ed 2016-11-15 HIVE-15208: The query string is now HTML encoded for Web UI.
f896f7d 2016-03-30 HIVE-13380: The decimal now has lower precedence than double in type hierarchy.
70af868 2016-07-22 HIVE-14251: Hive will now only perform implicit conversion within each type of group including string group, number group, or date group, and not across groups. So, in order to union a string type with a date type, an explicit cast from string to date or from date to string is needed.
f9517f0 2017-09-06 HIVE-12274: The width of metastore text columns for general configuration storage has now been increased.
4c8bfb3 2017-08-17 HIVE-14564: The issue that caused an exception when SelectOperator did column pruning is now fixed.