Hive Snap Pack
In this article
Overview
Hive provides a SQL-like interface to data stored in the Hadoop distributions, which includes Cloudera, Hortonworks, and others. You can use Snaps in this Snap Pack to execute arbitrary SQL.
The Hive Snap pack is Cloudera certified with the Cloudera Data Platform (CDP Public Cloud - 7.2.x).
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
Cloudera certified with the CDP Public Cloud - 7.2.x
Snaps in this Snap Pack support TLS/SSL protocols.
Snap Pack History
Release | Snap Pack Version | Date | Type |  Updates |
---|---|---|---|---|
November 2024 | main29029 | Nov 13, 2024 | Stable | Updated and certified against the current SnapLogic Platform release. |
August 2024 | main27765 | Aug 21, 2024 | Stable | Upgraded the |
May 2024 | main26341 | May 8, 2024 | Stable | Updated and certified against the current SnapLogic Platform release. |
February 2024 | main25112 | Feb 14, 2024 | Stable | Updated and certified against the current SnapLogic Platform release. |
November 2023 | main23721 | Nov 8, 2023 | Stable | Updated and certified against the current SnapLogic Platform release. |
August 2023 | main22460 | Aug 16, 2023 | Stable | The Hive-Execute Snap now includes a new Query type field. When Auto is selected, the Snap tries to determine the query type automatically. |
May 2023 | main21015 | May 10, 2023 | Stable | The Hive Snap Pack is Cloudera-certified for Cloudera Data Warehouse (CDW). You can use the Hive Execute Snap to work with CDW clusters through a Generic Hive Database account. |
February 2023 | main19844 | 09 Feb 2023Â | Stable | Upgraded with the latest SnapLogic Platform release. |
November 2022 | main18944 | 10 Nov 2022Â | Stable | Upgraded with the latest SnapLogic Platform release. |
August 2022 | main17386 | 11 Aug 2022 Â | Stable | Upgraded with the latest SnapLogic Platform release. |
4.29 | main15993 | 14 May 2022Â | Stable | Upgraded with the latest SnapLogic Platform release. |
4.28 | main14627 | 12 Feb 2022Â | Stable | Upgraded with the latest SnapLogic Platform release. |
4.27 | main12833 | 13 Nov 2021Â | Stable | Upgraded with the latest SnapLogic Platform release. |
4.26 | main11181 | 14 Aug 2021Â | Stable | Upgraded with the latest SnapLogic Platform release. |
4.25 | main9554 | 08 May 2021Â | Stable | Upgraded with the latest SnapLogic Platform release. |
4.24 Patch | 424patches8867 | 11 Mar 2021 | Latest | Fixes the missing library error in Hive Snap Pack when running Hadoop Pipelines in JDK11 runtime. |
4.24 | main8556 | 13 Feb 2021 | Stable | Upgraded with the latest SnapLogic Platform release. |
4.23 | main7430 | 14 Nov 2020Â | Stable | Upgraded with the latest SnapLogic Platform release. |
4.22 | main6403 | 12 Sep 2020Â | Stable | Upgraded with the latest SnapLogic Platform release. |
4.21 Patch | 421patches6272 | 27 Jul 2020Â | 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 | 02 Jul 2020Â | Latest | Fixes the following issues with DB Snaps:
|
4.21 Patch | 421patches5851 | 08 Jun 2020Â | Latest | Fixes the Hive Execute Snap that fails with a |
4.21 Patch | MULTIPLE8841 | 19 May 2020Â | Latest | Fixes the connection issue in Database Snaps by detecting and closing open connections after the Snap execution ends. |
4.21 | snapsmrc542 | 09 May 2020Â | Stable | Upgraded with the latest SnapLogic Platform release. |
4.20 | snapsmrc535 | 08 Feb 2020Â | Stable | Upgraded with the latest SnapLogic Platform release. |
4.19 | snaprsmrc528 | 14 Nov 2019Â | Stable | Upgraded with the latest SnapLogic Platform release. |
4.18 | snapsmrc523 | 10 Aug 2019Â | Stable | Upgraded with the latest SnapLogic Platform release. |
4.17 | ALL7402 | 11 Jun 2019 | Latest | Pushed automatic rebuild of the latest version of each Snap Pack to SnapLogic UAT and Elastic servers. |
4.17 | snapsmrc515 | 11 Jun 2019Â | Stable |
|
4.16 | snapsmrc508 | 16 Feb 2019Â | Stable | Upgraded with the latest SnapLogic Platform release. |
4.15 Patch | db/hive6330 | 05 Dec 2018 | 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 | 15 Dec 2018Â | Stable | Added Hive HA support for Zookeeper. |
4.14 | snapsmrc490 | 11 Aug 2018 | 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 | 07 Jun 2018 | Latest | Fixes the Hive Execute Snap that stores account passwords in plain text in the log file. |
4.13 | snapsmrc486 | 12 May 2018Â | Stable | Upgraded with the latest SnapLogic Platform release. |
4.12 | snapsmrc480 | 17 Feb 2018Â | Stable | Upgraded with the latest SnapLogic Platform release. |
4.11 | snapsmrc465 | 11 Nov 2017Â | Stable | Upgraded with the latest SnapLogic Platform release. |
4.10 | snapsmrc414 | 12 Aug 2017Â | Stable | Upgraded with the latest SnapLogic Platform release. |
4.9 Patch | hive3068 | 01 Jun 2017Â | Latest |
|
4.9 | snapsmrc405 | 13 May 2017Â | Stable |
|
4.8 Patch | hive2752 | 27 Mar 2017Â | Latest | Potential fix for JDBC deadlock issue. |
4.8 | snapsmrc398 | 11 Feb 2017Â | Stable |
|
4.7.0 Patch | hive2469 | 17 Jan 2017 | 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 | 28 Nov 2016 | Latest | Fixes an issue for database Select Snaps regarding Limit rows not supporting an empty string from a pipeline parameter. |
4.7 | snapsmrc382 | 23 Nov 2016Â | Stable |
|
4.6 Patch | hive1958 | 05 Oct 2016 | Latest | Resolved a performance issue with Hive Execute and JDBC Execute Snaps when running Hive Queries. |
4.6 | snapsmrc362 | 13 Aug 2016 | 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. |
Â
Have feedback? Email documentation@snaplogic.com | Ask a question in the SnapLogic Community
© 2017-2024 SnapLogic, Inc.