Hive provides a SQL-like interface to data stored in the Hadoop distributions, which includes Cloudera, Hortonworks, and others. You can useSnaps in this Snap Pack to execute arbitrary SQL.
Info
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
Cloudera certified with the CDP Public Cloud - 7.2.x
Info
Snaps in this Snap Pack support TLS/SSL protocols.
Panel
bgColor
#ebf7e1
borderStyle
solid
In this Section
Child pages (Children Display)
all
true
depth
2
Snap Pack History
Excerpt
name
Hive_SPH
Release
Snap Pack Version
Date
Type
Updates
August 2024
main27765
Stable
Upgraded the org.json.json library from v20090211 to v20240303, which is fully backward compatible.
May 2024
main26341
2024
Stable
Updated and certified against the current SnapLogic Platform release.
February 2024
main25112
Stable
Updated and certified against the current SnapLogic Platform release.
November 2023
main23721
Stable
Updated and certified against the current SnapLogic Platform release.
August 2023
main22460
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
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-historizationfields 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:
The connection thread waits indefinitely causing the subsequent connection requests to become unresponsive.
Connection leaks occur during Pipeline execution.
4.21 Patch
421patches5851
08 Jun 2020
Latest
Fixes the Hive Execute Snap that fails with a java.lang.NullPointerException error.
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
Certified and tested the Snap Pack against CDH 6.1.
Fixes an issue with the Hive Execute Snap wherein the Snap would send the input document to the output view even if the Pass through field is not selected in the Snap configuration. With this fix, the Snap sends the input document to the output view, under the key original, only if you select the Pass through field.
Adds the Snap Execution field to all Standard-mode Snaps. In some Snaps, this field replaces the existing Execute during preview check box.
Adds a new authentication method, User ID and Password with SSL, for Hive SSL Accounts which allows SSL connections for valid user name and password credentials.
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 testperiod 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
Fixes an issue regarding connection not closed after login failure; Expose autocommit for "Select into" statement in PostgreSQL Execute Snap and Redshift Execute Snap
4.9
snapsmrc405
13 May 2017
Stable
Hive - Execute Snap is tested on Cloudera Version 5.8.
Hive - Execute Snap(Kerberos) now works on Groundplex.
4.8 Patch
hive2752
27 Mar 2017
Latest
Potential fix for JDBC deadlock issue.
4.8
snapsmrc398
11 Feb 2017
Stable
Info tab added to accounts.
Database accounts now invalidate connection pools if account properties are modified and login attempts fail.
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
The editor box for the SQL statement property in certain database Snaps can now be resized to make it easier to read the contents. This setting is in the Execute Snaps for Cassandra, Hive, JDBC, Oracle, MySQL, SQL Server, PostgreSQL, SAP HANA, Vertica, and Teradata.
Enabled the Hive account with Kerberos authentication (Hive with Kerberos works only on Hive JDBC4 driver 2.5.12 and above).
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.