Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This section describes the transaction behavior of the Data Hub agent. For more information about general transactions, see, Transactions, in /wiki/spaces/MZD73/pages/5605083.

Emits

This agent does not emit anything.

Retrieves

The agent retrieves commands from other agents . Based on these commands the agent changes the state of the processed local fileand based on them generates a state change of the file currently processed.

Command

Description

Begin Batch

When a Begin Batch message is received a local temporary file is created in MZ_HOME/tmp.

ConsumeWhen a consume message is received the agent will write the incoming data to the local temporary file.

Commit

When a Commit message is received, the agent will send the local temporary file to the staging directory in Impala. Once the file has been transferred, the agent will insert the transferred data into a temporary database table. The agent then copies the data in the temporary table to the selected database table and removes all temporary files and tables.

If the agent is recovering from an error, the agent will only remove the local temporary file.

RollbackIf a Rollback message is received, the agent will remove the local temporary file

Retrieves a Transaction ID and inserts an entry in the pending transaction table.

End Batch

Deletes the pending Transaction ID row.

Cancel Batch

Removes the distributed rows with the current Transaction ID or calls the configured Cleanup SP. The pending Transaction ID row is deleted.