[PHOENIX-6411] Verify and add transactions usability in Phoenix Spark connector

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: connectors-6.0.0
• Component/s: spark-connector
• Assignee: Rajeshbabu Chintaguntla
• Reporter: Rajeshbabu Chintaguntla
• Created: 11/Mar/21 19:17
• Updated: 26/Aug/22 05:53
• Resolved: 24/Aug/22 00:42

Description

Currently there is
1) no way to disable/enable autocommit for the connections creating internally within the readers/writers and
2) commits are getting called internally when batch size reaches which will not give control to application developer.
3) No way to explicit commits (write on Dataset should call commit explicitly any way)
Avoiding these may help to use transactions with in the connector.

Sub-Tasks

• Handle rollbacks in phoenix spark connector and add way to control batch wise or task wise transactions: Resolved