In this article

Table of Contents

minLevel	1
maxLevel	6
outline	false
type	list
printable	false

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 let you:

execute arbitrary SQL

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 Version:
Hive 1.1.0
,
CDH
Hive 1.2.1 on HDP
Hive
with Kerberos works
with Kerberos works only on Hive JDBC4 driver 2.5.12 and above
Hive
with Kerberos is
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

note

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
November 2024	main29029	13 Nov 2024	Stable	Updated and certified against the current SnapLogic Platform release.
August 2024	main27765	21 Aug 2024	Stable	Upgraded the `org.json.json` library from v20090211 to v20240303, which is fully backward compatible.
May 2024	main26341	08 May 2024	Stable	Updated and certified against the current SnapLogic Platform release.
February 2024	main25112	14 Feb 2024	Stable	Updated and certified against the current SnapLogic Platform release.
November 2023	main23721	08 Nov 2023	Stable	Updated and certified against the current SnapLogic Platform release.
August 2023	main22460	16 Aug 2023	Stable	The Hive-Execute Snap now includes a new Query type field. When Auto is selected, the Snap

Pack History Expand

title	Click to view/expand

4.25 (main9554)

No updates made

tries to determine the query type automatically.
May 2023	main21015	10 May 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 1438323

in Hive Snap Pack when running Hadoop Pipelines in JDK11 runtime.

4.24

(main8556)No updates made

	main8556	13 Feb 2021	Stable	Upgraded with the latest SnapLogic Platform release.
4.23

(main7430)No updates made

	main7430	14 Nov 2020	Stable	Upgraded with the latest SnapLogic Platform release.
4.22

(main6403)No updates made

	main6403	12 Sep 2020	Stable	Upgraded with the latest SnapLogic Platform release.
4.21

Patch 421patches6272

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:

The connection thread waits indefinitely causing the subsequent connection requests to become unresponsive.
Connection leaks occur during Pipeline execution.

4.21

Patch

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)No updates made

	snapsmrc542	09 May 2020	Stable	Upgraded with the latest SnapLogic Platform release.
4.20

(snapsmrc535)No updates made

	snapsmrc535	08 Feb 2020	Stable	Upgraded with the latest SnapLogic Platform release.
4.19

(snapsmrc528)No updates made

	snaprsmrc528	14 Nov 2019	Stable	Upgraded with the latest SnapLogic Platform release.
4.18

(snapsmrc523)No updates made

	snapsmrc523	10 Aug 2019	Stable	Upgraded with the latest SnapLogic Platform release.
4.17

Patch ALL7402

	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)

snapsmrc515

11 Jun 2019

Stable

Certified and tested the Snap Pack against CDH 6.1.
Fixes an issue with

the Hive

the Hive Execute

Snap wherein

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

Accounts which allows SSL connections for valid user name and password credentials.

4.16

(snapsmrc508)No updates made. Automatic rebuild with a platform

	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)

	snapsmrc500	15 Dec 2018	Stable	Added Hive HA support for Zookeeper.
4.14

(snapsmrc490)

snapsmrc490

11 Aug 2018

Stable

Added a new account type: Generic Hive Database Account,

this

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)No updates made. Automatic rebuild with a platform

	snapsmrc486	12 May 2018	Stable	Upgraded with the latest SnapLogic Platform release.
4.12

(snapsmrc480)No updates made. Automatic rebuild with a platform

	snapsmrc480	17 Feb 2018	Stable	Upgraded with the latest SnapLogic Platform release.
4.

11 (snapsmrc465)No updates made. Automatic rebuild with a platform

11	snapsmrc465	11 Nov 2017	Stable	Upgraded with the latest SnapLogic Platform release.
4.10

(snapsmrc414)No updates made. Automatic rebuild with a platform

	snapsmrc414	12 Aug 2017	Stable	Upgraded with the latest SnapLogic Platform release.
4.9

.0

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

.0 (snapsmrc405)

	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

.0 Patch

Patch	hive2752	27 Mar 2017	Latest	Potential fix for JDBC deadlock issue.
4.8

(snapsmrc398)

	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

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

.0 (snapsmrc382)

	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

.0

Patch	hive1958	05 Oct 2016	Latest	Resolved a performance issue with Hive Execute and JDBC Execute Snaps when running Hive Queries.
4.6

.0 (snapsmrc362)

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

on Cloudera CDH 5.3 & 5.5,

Hortonworks HDP

Hortonworks HDP 2.3.4.

Versions Compared

Old Version 61

New Version Current

Key

Overview

Supported Versions

Snap Pack History

Page Comparison

Versions Compared

Old Version 61

New Version Current

Key

Overview

Supported Versions

Snap Pack History