Capabilities for SingleStore

Last updated on Jan 05, 2021

Contents

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

Capture

HVR does not support Capture changes from location on SingleStore.

Hub Database

HVR does not support Hub database on SingleStore.

Integrate

HVR supports the following capabilities on SingleStore:

  • Integrate changes into location (SingleStore version 7.1).
  • Integrate with /Burst (SingleStore version 7.1).
  • Integrate with /BurstCommitFrequency (SingleStore version 7.1).
  • Continuous integration (Integrate without /Burst) (SingleStore version 7.1).
  • Action TableProperties with /DuplicateRows for continuous integration (SingleStore version 7.1).
  • Action Transform /SoftDelete (SingleStore version 7.1).
  • Bulk load requires a staging area (LocationProperties /StagingDirectoryHvr) (SingleStore version 7.1).
  • Creation and update of HVR state tables (SingleStore version 7.1).

HVR does not support the following capabilities on SingleStore:

  • Continuous Integrate with /OnErrorSaveFailed (without /Burst).
  • Disable/enable database triggers during Integrate (/NoTriggerFiring).
  • Integrate with /DbProc.

Bi-directional Replication

HVR does not support Bi-directional Replication on SingleStore.

Refresh and Compare

HVR supports the following capabilities on SingleStore:

  • Hvrrefresh or Hvrcompare from source location (SingleStore version 7.1).
  • Hvrrefresh into target location (SingleStore version 7.1).
  • Row-wise Hvrrefresh into target location (option -g) (SingleStore version 7.1).

Other Capabilities

HVR supports the following capabilities on SingleStore:

  • Both row store and column store tables can be created (SingleStore version 7.1).
  • Use distribution key for parallelizing changes within a table (ColumnProperties /DistributionKey) (SingleStore version 7.1).
  • Call database procedure dbproc during replication jobs (action AgentPlugin /DbProc) (SingleStore version 7.1).
  • International table and column names where DBMS is not configured with UTF-8 encoding (SingleStore version 7.1).
  • Treat DBMS table names and columns case sensitive (action LocationProperties /CaseSensitiveNames) (SingleStore version 7.1).
  • Always treat DBMS table names and column names case sensitive (SingleStore version 7.1).
  • Always treat DBMS schema names case sensitive (SingleStore version 7.1).

HVR does not support the following capabilities on SingleStore:

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