Capabilities for Hive ACID

Last updated on Jan 05, 2021

Contents

This section lists the Capabilities of HVR when using 'Hive ACID'. For more information about the pre-requisites, access privileges, and other configuration requirements, see Requirements for Hive ACID.

Capture

HVR does not support Capture changes from location on Hive ACID.

Hub Database

HVR does not support Hub database on Hive ACID.

Integrate

HVR supports the following capabilities on Hive ACID:

  • Integrate changes into location (Hive ACID from version 2.1.0 to version 3.1.0).
  • Integrate with /Burst (Hive ACID from version 2.1.0 to version 3.1.0).
  • Action Transform /SoftDelete (Hive ACID from version 2.1.0 to version 3.1.0).
  • Bulk load requires a staging area (LocationProperties /StagingDirectoryHvr) (Hive ACID from version 2.1.0 to version 3.1.0).

HVR does not support the following capabilities on Hive ACID:

  • Integrate with /BurstCommitFrequency.
  • Continuous integration (Integrate without /Burst).
  • Action TableProperties with /DuplicateRows for continuous integration.
  • Continuous Integrate with /OnErrorSaveFailed (without /Burst).
  • Disable/enable database triggers during Integrate (/NoTriggerFiring).
  • Creation and update of HVR state tables.
  • Integrate with /DbProc.

Bi-directional Replication

HVR does not support Bi-directional Replication on Hive ACID.

Refresh and Compare

HVR supports the following capabilities on Hive ACID:

  • Hvrrefresh or Hvrcompare from source location (Hive ACID from version 2.0.0 to version 3.1.0).
  • Hvrrefresh into target location (Hive ACID from version 2.0.0 to version 3.1.0).

Other Capabilities

HVR supports the following capabilities on Hive ACID:

  • Use distribution key for parallelizing changes within a table (ColumnProperties /DistributionKey) (Hive ACID from version 2.0.0 to version 3.1.0).
  • International table and column names where DBMS is not configured with UTF-8 encoding (Hive ACID from version 2.0.0 to version 3.1.0).

HVR does not support the following capabilities on Hive ACID:

  • Lossless binary float datatypes. No dataloss when transporting float values (because base 2 fractions are never converted to base 10).