Versions Compared

Old Version 62

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

Saved on

compared with

New Version Current

changes.mady.by.user Amritesh Singh

Saved on

Key

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

In this article

Table of Contents
minLevel1
maxLevel6
outlinefalse
typelist
printablefalse

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
borderStylesolid

In this Section

Child pages (Children Display)
alltrue
depth2

excerpt


Snap Pack History

expandClick to view/expand
Excerpt
title
nameHive_SPH

Release 

Snap Pack Version

Date

Type

  Updates

November 2024

main29029

Stable

Updated and certified against the current SnapLogic Platform release.

August 2024

main27765

Stable

Upgraded the org.json.json library from v20090211 to v20240303, which is fully backward compatible.

May 2024

main26341

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 

2021 

Stable

Upgraded with the latest SnapLogic Platform release.

4.24 Patch

424patches8867

11 Mar

2021 

2021 

Latest

Fixes the missing library error

in 

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 

2020 

Stable

Upgraded with the latest SnapLogic Platform release.

4.22

main6403

12 Sep

2020 

2020 

Stable

Upgraded with the latest SnapLogic Platform release.

4.21 Patch

421patches6272

27 Jul

2020 

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 

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 

2020 

Latest

Fixes the Hive Execute Snap that fails with a

 

java.lang.NullPointerException

 

error.

4.21 Patch

MULTIPLE8841

19 May

2020 

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 

2020 

Stable

Upgraded with the latest SnapLogic Platform release.

4.20

snapsmrc535

08 Feb

2020 

2020 

Stable

Upgraded with the latest SnapLogic Platform release.

4.19

snaprsmrc528

14 Nov

2019 

2019 

Stable

Upgraded with the latest SnapLogic Platform release.

4.18

snapsmrc523

10 Aug

2019 

2019 

Stable

Upgraded with the latest SnapLogic Platform release.

4.17

ALL7402

11 Jun

2019 

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 

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

16 Feb

2019 

2019 

Stable

Upgraded with the latest SnapLogic Platform release.

4.15 Patch 

db/hive6330

05 Dec

2018 

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 

2018 

Stable

Added Hive HA support for Zookeeper.

4.14

snapsmrc490

11 Aug

2018 

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 

2018 

Latest

Fixes the Hive Execute Snap that stores account passwords in plain text in the log file. 

4.13

snapsmrc486

12 May

2018 

2018 

Stable

Upgraded with the latest SnapLogic Platform release.

4.12

snapsmrc480

17 Feb

2018 

2018 

Stable

Upgraded with the latest SnapLogic Platform release.

4.11

snapsmrc465

11 Nov

2017 

2017 

Stable

Upgraded with the latest SnapLogic Platform release.

4.10

snapsmrc414

12 Aug

2017 

2017 

Stable

Upgraded with the latest SnapLogic Platform release.

4.9 Patch

hive3068

01 Jun

2017 

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 

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 

2017 

Latest

Potential fix for JDBC deadlock issue.

4.8

snapsmrc398

11 Feb

2017 

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 

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 

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 

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 

2016 

Latest

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

4.6

snapsmrc362

13 Aug

2016 

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.