Vertica component release notes

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

Changelog

Version 2024.1.5

Features

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

Version 2024.1.0

Features

  • DI-8088: Add missing process tool TOOL Vertica to Parquet to Vertica component.

Version 2023.4.0

Features

  • DI-6620: Support writing hierarchical data in ARRAY and ROW data types.

Version 2023.3.0

Features

  • DI-6619: Support designing and reading hierarchical data contained in ARRAY and ROW data types.

Version 2023.1.13

New Features

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

Version 2023.1.12

New Features

  • 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

Features

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

Features

  • DI-5910: Support geography datatype.

Version 5.3.5 (component pack)

Features

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

Features

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

Features

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

Features

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