What's New in Apache Hive

Learn about the new features of Hive in Cloudera Runtime 7.1.9.

HiveServer graceful shutdown

You can now configure the graceful shutdown timeout property for HiveServer (HS2), which ensures that HS2 waits for a specified time period before shutting down, thereby allowing queries that are already running to complete before HS2 stops. For more information, see Configuring graceful shutdown property for HiveServer

Support for HPL/SQL

Cloudera Data Platform (CDP) supports Hive Hybrid Procedural SQL (HPL/SQL). HPL/SQL is an Apache open source procedural extension for SQL for Hive users. HPL/SQL includes imperative programming structures (variables, procedures, control flow, and exceptions), and is typically used for ETL. The HPL/SQL language understands the syntax and semantics of most procedural SQL dialects, such as Oracle PL/SQL. For more information, see HPL/SQL stored procedures

Hive Metastore dynamic leader election

You can use Hive Metastore (HMS) leader election to avoid running the same tasks across all Hive Metastore (HMS) instances by either configuring a HMS leader manually or enabling dynamic election. Dynamic leader election feature uses Hive locks to dynamically elect a leader. When a HMS instance owns a lock, it is elected as the leader and performs the housekeeping tasks. The HMS regularly sends heartbeats to prevent the lock from timing out. For more information, see Hive Metastore leader election.

Hive audit logging improvement

Youc an configure the HDFS audit logs to include the caller context in the logs. This allows Hive to audit partitions that are scanned as part of a Hive query. The audit information comprises the Query ID and User ID, which helps in meeting compliance requirements, such as controlling user access to data from specific regions or access only to particular time periods. For more information, see Configuring query audit logs to include caller context.

Hive Metastore supports TLS 1.2 for secured database connections

Hive Metastore supports connections to backend databases that are secured with Transport Layer Security (TLS) 1.2 encryption. This enhances the security connections between CDP and backend databases, such as MySQL, PostgreSQL, MariaDB. For more information, see Configuring Hive Metastore to connect to TLS-enabled database.

Hive Metastore supports connections to a TCPS-enabled Oracle database

Hive Metastore supports connections to backend Oracle databases that are secured with Transmission Control Protocol with SSL (TCPS). This provides greater security for connections between CDP and the backend Oracle database. For more information, see Configuring Hive Metastore to connect to TCPS-enabled Oracle database.