Vertica Component Release Notes

This page lists the main features added to the Vertica Component.

Feature Highlights

Version 2.0.4

Minor improvements and fixed issues

This version contains some minor improvements and fixed issues, which can be found in the complete changelog.

Version 2.0.3

Change Data Capture (CDC)

Multiple improvements have been performed to homogenize the usage of Change Data Capture (CDC) in the various Components.

Parameters have been homogenized, so that all Templates should now have the same CDC Parameters, with the same support of features.

Multiple fixes have also been performed to correct CDC issues. Refer to the changelog for the exact list of changes.

Version 2.0.2

Sample project

The component example project can now be imported directly in the "New" menu of the Project Explorer.

Version 2.0.1

Load File to Vertica (with copy)

New parameter xfieldSep

A new parameter 'xfieldSep' has been added.

It specifies the hexadecimal code of the Field Separator to be used in the temporary file imported into Vertica.

Examples: 08 = backspace, 09 = tab, 1F = ascii unit separator

this option is taken into acount only when 'Force Pre Transform File' is set to 'true'. The default value is 08.

INTEGRATION Vertica

Fix creation of temporary integration table when "usingExportObject" is used

Some issues were encountered when using "usingExportObject" mode for "Create Integration Table Like Target Table" parameter with some Vertica database versions.

Queries have been fixed for this mode to work as expected with the different Vertica database versions.

Fix expressions used for generating a row id

Expressions used in the various queries to create a row id have been fixed to use the correct syntax.

They were using an order by expression which was not supported by Vertica and not useful.

Fix expression used for projection name

Expression used when creating projections is now using properly the temporary work name.

Change Log

Version 2023.1.14

Bug fixes

  • DI-9749: Fixed an issue which prevented the Vertica Export Object Parser from parsing primary keys.

Version 2023.1.13

Feature improvements

  • DI-6842: Added constraint enforcement option on primary keys.

Version 2023.1.12

Feature improvements

  • DI-6619: Added support for designing and reading hierarchical data inside ARRAY and ROW datatypes.

  • DI-6620: Added support for writing hierarchical data in ARRAY and ROW datatypes.

Version 2023.1.7

Bug fixes

  • DI-8088: Process tool Vertica to Parquet missing from Vertica component

Version 2023.1.0

Feature improvements

  • DI-4522: A dedicated parser to parse Vertica’s EXPORT_OBJECTS command has been added to the Vertica component and is used in its templates.

  • DI-5735: The GEOMETRY datatype is now supported.

  • DI-5910: The GEOGRAPHY datatype is now supported.

Bug fixes

  • DI-5715: In the INTEGRATION Vertica template, the Slowly Changing Dimension mode is not efficient and causes memory overconsumption.

  • DI-5716: The INTEGRATION Vertica template generates duplicate rows on the target table when the Integration Strategy parameter is set to Slowly Changing Dimension mode and the Useless Update Detection Method parameter is set to disable.

  • DI-5797: In the INTEGRATION Vertica template, the NULL and NOT NULL clauses are unexpectedly hardcoded for the work table columns instead of being automatically computed.

Version 5.3.7 (Component Pack)

Feature improvements

  • DI-5910: Support geography datatype.

Version 5.3.5 (Component Pack)

Feature improvements

  • DI-5735 : Support geometry datatype.

Bug fixes

  • DI-5797 : Template - INTEGRATION Vertica - the NULL and NOT NULL clauses are unexpectedly hardcoded for the work table columns, instead of being automatically computed.

  • DI-5716 : Template - INTEGRATION Vertica: Slowly Changing Dimension mode creates duplicated rows on target when the "Useless Update Detection Method" parameter is set to disable.

  • DI-5715 : Template - INTEGRATION Vertica: Slowly Changing Dimension mode is not efficient and causes memory overconsumption.

Version 3.0.0 (Component Pack)

Feature improvements

  • DI-4508: Update Components and Designer to take into account dedicated license permissions

  • DI-4727: Rebranding: Templates and sample projects

  • DI-4731: Rebranding: Template messages

  • DI-4962: Improved component dependencies and requirements management

Version 2.0.4 (Vertica Component)

Feature improvements

  • DI-2768: TOOL Vertica Move partitions - new parameter "Force Split"

Bug fixes

  • DI-2752: Template - LOAD Rdbms to Vertica (with COPY) - generated temporary file names may unexpectedly contain object delimiters

Version 2.0.3 (Vertica Component)

Feature improvements

  • DI-1910: Templates updated - New parameter 'Cdc Subscriber' on Templates on which it was not handled yet

  • DI-1909: Templates updated - New Parameters 'Unlock Cdc Table' and 'Lock Cdc Table' to configure the behaviour of CDC tables locking

Bug fixes

  • DI-1908: Templates updated - The 'Cdc Subscriber' parameter was ignored in some Templates on Lock / Unlock CDC steps

  • DI-1907: Templates updated - The 'Cdc Subscriber' parameter was ignored in some Templates when querying the source data