Versions Compared

Old Version 61

changes.mady.by.user Siddharth Menon (Unlicensed)

Saved on

compared with

New Version 62

changes.mady.by.user Siddharth Menon (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Hive provides a SQL-like interface to data stored in the Hadoop distributions, which includes Cloudera, Hortonworks, and others. 

Snaps in this Snap Pack let you:

  • execute arbitrary SQL.

Supported Versions

This Snap Pack is tested against:

  • Hive Version: Hive 1.1.0, Hive 1.2.1
  • 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
Note

Snaps in this Snap Pack support TLS/SSL protocols.




Panel
bgColor#ebf7e1
borderStylesolid

In this Section

Child pages (Children Display)
alltrue
depth2


Excerpt

Snap Pack History

Expand
titleClick to view/expand


Release Snap Pack VersionDateType  Updates
4.25
(main9554)No updates made
main9554
 
StableUpgraded with the latest SnapLogic Platform release.
4.24 Patch424patches8867 Latest

Fixes the missing library error in 

1438323

Hive Snap Pack when running Hadoop Pipelines in JDK11 runtime.

4.24
(main8556)No updates made
main8556
StableUpgraded with the latest SnapLogic Platform release.
4.23
(main7430)No updates made
main7430
 
StableUpgraded with the latest SnapLogic Platform release.
4.22
(main6403)No updates made
main6403
 
StableUpgraded with the latest SnapLogic Platform release.
4.21
Patch 421patches6272
Patch421patches6272 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 Patch421patches6144 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 
Patch421patches5851 Latest

Fixes the Hive Execute Snap that fails with a java.lang.NullPointerException error.

4.21 PatchMULTIPLE8841 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

 

StableUpgraded with the latest SnapLogic Platform release.
4.20
(snapsmrc535)No updates made
snapsmrc535
 
StableUpgraded with the latest SnapLogic Platform release.
4.19
(snapsmrc528)No updates made
snaprsmrc528
 
StableUpgraded with the latest SnapLogic Platform release.
4.18
(snapsmrc523)No updates made
snapsmrc523
 
StableUpgraded with the latest SnapLogic Platform release.
4.17
Patch 
ALL7402
 
Latest

Pushed automatic rebuild of the latest version of each Snap Pack to SnapLogic UAT and Elastic servers.

4.17
(snapsmrc515)
snapsmrc515
 
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)No updates made. Automatic rebuild with a platform
snapsmrc508
 
StableUpgraded with the latest SnapLogic Platform release.
4.15 Patch db/
hive6330 
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)
snapsmrc500
 
Stable

Added Hive HA support for Zookeeper.

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

snapsmrc486

 
StableUpgraded with the latest SnapLogic Platform release.
4.12
(snapsmrc480)No updates made. Automatic rebuild with a platform

snapsmrc480

 
StableUpgraded with the latest SnapLogic Platform release.
4.
11 (snapsmrc465)No updates made. Automatic rebuild with a platform
11snapsmrc465
 
StableUpgraded with the latest SnapLogic Platform release.
4.10
(snapsmrc414)No updates made. Automatic rebuild with a platform

snapsmrc414

 
StableUpgraded with the latest SnapLogic Platform release.
4.9
.0
Patchhive3068 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
 
Stable
  • Hive - Execute Snap is tested on Cloudera Version 5.8.
  • Hive - Execute Snap(Kerberos) now works on Groundplex.
4.8
.0 Patch hive2752
Patchhive2752 Latest

Potential fix for JDBC deadlock issue.

4.8
(snapsmrc398)

snapsmrc398

 
Stable

  • Info tab added to accounts.

  • Database accounts now invalidate connection pools if account properties are modified and login attempts fail.

4.7.0 Patchhive2469 Latest

Addresses an issue

with

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 Patchhive2199

 

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

 
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
Patchhive1958 Latest

Resolved a performance issue with Hive Execute and JDBC Execute Snaps when running Hive Queries.

4.6
.0 (snapsmrc362)
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.