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.