4.27

main12833

13 Nov 2021 

Stable

Fixes the missing library error in Hive Snap Pack when running Hadoop Pipelines in JDK11 runtime.

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.

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.

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

Fixes the connection issue in Database Snaps by detecting and closing open connections after the Snap execution ends.

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

• 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.

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.

Added Hive HA support for Zookeeper.

Added a new account type: Generic Hive Database Account, this enables connecting to different types of clusters using JDBC URL.

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

snapsmrc486

snapsmrc480

snapsmrc414

• Fixes an issue regarding connection not closed after login failure; Expose autocommit for "Select into" statement in PostgreSQL Execute Snap and Redshift Execute Snap

• Hive - Execute Snap is tested on Cloudera Version 5.8.
• Hive - Execute Snap(Kerberos) now works on Groundplex.

Potential fix for JDBC deadlock issue.

snapsmrc398

• Info tab added to accounts.

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

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.

Fixes an issue for database Select Snaps regarding Limit rows not supporting an empty string from a pipeline parameter.

snapsmrc382

• 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).

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