Actian Avalanche component release notes

This page lists the main features added to the Actian Avalanche Component.

Changelog

Version 2023.1.5

Bug fixes

  • DI-6411: Integration VectorWise template: the insertion of rows in the target table fails when preceded by an update.

Version 2023.1.0

Feature improvements

  • DI-5747: The Actian Avalanche component is now available.

  • DI-6083: The templates have been updated to use the MODIFY…​TO COMBINE statement instead of the deprecated CALL VECTORWISE […​] COMBINE statement.

  • DI-6210: The Load BigQuery to Avalanche template now supports using the copy vwload command as an alternative to external tables.

Version 5.3.9 (Component pack)

Feature improvements

  • DI-6565: The COPY VWLOAD Strict Nulls parameter has been added to the LOAD BigQuery to Avalanche template. When selected, this parameter makes a distinction between null values and empty values in BigQuery CSV files.

Bug fixes

  • DI-6412: The default value of the Null Value Replacement parameter in the LOAD BigQuery to Avalanche template is null. Due to this, the COPY VWLOAD command fails for date fields.

  • DI-6436: Existing GCS files from a previous failed extraction job are not deleted when the job is executed again causing data issues like duplicates or invalid data.

  • DI-6437: The joinPart, groupByPart and havingPart clauses are missing from the SELECT BigQuery source statement.

Version 5.3.9 (component pack)

Feature improvements

  • DI-6565: The COPY VWLOAD Strict Nulls parameter has been added to the LOAD BigQuery to Avalanche template. When selected, this parameter makes a distinction between null values and empty values in BigQuery CSV files.

Bug fixes

  • DI-6412: The default value of the Null Value Replacement parameter in the LOAD BigQuery to Avalanche template is null. Due to this, the COPY VWLOAD command fails for date fields.

  • DI-6436: Existing GCS files from a previous failed extraction job are not deleted when the job is executed again causing data issues like duplicates or invalid data.

  • DI-6437: The joinPart, groupByPart and havingPart clauses are missing from the SELECT BigQuery source statement.

Version 5.3.8 (component pack)

Feature improvements

  • DI-6340: The Copy VWLOAD Error Limit and Copy VWLOAD Quote options have been added to the LOAD BigQuery to Avalanche template.

  • DI-6242: The Copy VWLOAD Error Limit and Copy VWLOAD Quote options have been added to the LOAD RDBMS to Avalanche template.

Bug fixes

  • DI-6322: Avalanche load templates ignore the storage folder and write files in the bucket’s root folder. Morever when the mapping is executed, the clean step fails to delete the temporary files.

  • DI-6321: In mappings, Avalanche load templates fail to use the alias of the source datastore, thus generating an incorrect query for exporting data.

Version 5.3.7 (component pack)

Feature improvements

  • DI-6210: Template - Load BigQuery to Avalanche: Support using copy vwload command as an alternative to external tables.

  • DI-6083: Update the templates to use the MODIFY…​TO COMBINE statement instead of CALL VECTORWISE […​] COMBINE which is deprecated.

Version 5.3.6 (component pack)

Feature improvements

  • DI-5747: Add Actian Avalanche component.