Capabilities for Hive ACID
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).