Hive Snap Pack
Overview
Hive provides a SQL-like interface to data stored in the Hadoop distributions, which includes Cloudera, Hortonworks, and others.
Use Snaps in this Snap Pack to execute arbitrary SQL.
Supported Versions
This Snap Pack is tested against:
Hive 1.1.0 CDH
Hive 1.2.1 on HDP
- Hive with Kerberos works only on Hive JDBC4 driver 2.5.12 and above
- Hive with Kerberos is tested on Groundplex
- Cluster Version: CDH 6.1, CDH 5.16.1, CDH 5.10, HDP 2.6.1, HDP 2.6.5
Snaps in this Snap Pack support TLS/SSL protocols.
Snap Pack History
Release | Snap Pack Version | Date | Type | Updates |
---|---|---|---|---|
4.29 | main15993 | Stable | Upgraded with the latest SnapLogic Platform release. | |
4.28 | main14627 | Stable | Upgraded with the latest SnapLogic Platform release. | |
4.27 | main12833 |
| Stable | Upgraded with the latest SnapLogic Platform release. |
4.26 | main11181 | Stable | Upgraded with the latest SnapLogic Platform release. | |
4.25 | main9554 | Stable | Upgraded with the latest SnapLogic Platform release. | |
4.24 Patch | 424patches8867 | Latest | Fixes the missing library error in Hive Snap Pack when running Hadoop Pipelines in JDK11 runtime. | |
4.24 | main8556 | Stable | Upgraded with the latest SnapLogic Platform release. | |
4.23 | main7430 | Stable | Upgraded with the latest SnapLogic Platform release. | |
4.22 | main6403 | Stable | Upgraded with the latest SnapLogic Platform release. | |
4.21 Patch | 421patches6272 | Latest | Fixes the issue where Snowflake SCD2 Snap generates two output documents despite no changes to Cause-historization fields with DATE, TIME and TIMESTAMP Snowflake data types, and with Ignore unchanged rows field selected. | |
4.21 Patch | 421patches6144 | Latest | Fixes the following issues with DB Snaps:
| |
4.21 Patch | 421patches5851 | Latest | Fixes the Hive Execute Snap that fails with a | |
4.21 Patch | MULTIPLE8841 | Latest | Fixes the connection issue in Database Snaps by detecting and closing open connections after the Snap execution ends. | |
4.21 | snapsmrc542 |
| Stable | Upgraded with the latest SnapLogic Platform release. |
4.20 | snapsmrc535 | Stable | Upgraded with the latest SnapLogic Platform release. | |
4.19 | snaprsmrc528 | Stable | Upgraded with the latest SnapLogic Platform release. | |
4.18 | snapsmrc523 | Stable | Upgraded with the latest SnapLogic Platform release. | |
4.17 | ALL7402 | Latest | Pushed automatic rebuild of the latest version of each Snap Pack to SnapLogic UAT and Elastic servers. | |
4.17 | snapsmrc515 | Stable |
| |
4.16 | snapsmrc508 | Stable | Upgraded with the latest SnapLogic Platform release. | |
4.15 Patch | db/hive6330 | Latest | Replaced Max idle time and Idle connection test period properties with Max life time and Idle Timeout properties respectively, in the Account configuration. The new properties fix the connection release issues that were occurring due to default/restricted DB Account settings. | |
4.15 | snapsmrc500 | Stable | Added Hive HA support for Zookeeper. | |
4.14 | snapsmrc490 | Stable | Added a new account type: Generic Hive Database Account, this enables connecting to different types of clusters using JDBC URL. | |
4.13 Patch | db/hive5269 | Latest | Fixes the Hive Execute Snap that stores account passwords in plain text in the log file. | |
4.13 | snapsmrc486 | Stable | Upgraded with the latest SnapLogic Platform release. | |
4.12 | snapsmrc480 | Stable | Upgraded with the latest SnapLogic Platform release. | |
4.11 | snapsmrc465 | Stable | Upgraded with the latest SnapLogic Platform release. | |
4.10 | snapsmrc414 | Stable | Upgraded with the latest SnapLogic Platform release. | |
4.9 Patch | hive3068 | Latest |
| |
4.9 | snapsmrc405 | Stable |
| |
4.8 Patch | hive2752 | Latest | Potential fix for JDBC deadlock issue. | |
4.8 | snapsmrc398 | Stable |
| |
4.7.0 Patch | hive2469 | Latest | Addresses an issue with ClouderaHiveJDBCDriver(500168) Unable to connect to server: GSS initiate failed, Fixes by changing the connection pooling to Hikari and added privileged user to all getConnect() request. | |
4.7.0 Patch | hive2199 |
| Latest | Fixes an issue for database Select Snaps regarding Limit rows not supporting an empty string from a pipeline parameter. |
4.7 | snapsmrc382 | Stable |
| |
4.6 Patch | hive1958 | Latest | Resolved a performance issue with Hive Execute and JDBC Execute Snaps when running Hive Queries. | |
4.6 | snapsmrc362 | Stable | Snap Pack introduced in 4.6.0. This includes only a Hive Execute Snap that executes DML and DDL statements with Kerberos enabled. It does not include Snaps for load, select, insert, delete, execute or others at this time. Tested only on Cloudera CDH 5.3 & 5.5, Hortonworks HDP 2.3.4. |