[BEAM-3506] JdbcIO: Support writing iterables (i.e. collections) of rows instead of only single rows

• Type: Improvement
• Status: Resolved
• Priority: P3
• Resolution: Won't Fix
• Affects Version/s: 2.3.0
• Fix Version/s: Not applicable
• Component/s: io-java-jdbc
• Labels: JdbcIO jdbc
• Assignee: Jean-Baptiste Onofré
• Reporter: Knut Olav Loite
• Created: 21/Jan/18 05:33
• Updated: 24/Jul/20 20:14
• Resolved: 30/Jan/18 00:51

Description

The current JdbcIO write interface expects a PCollection<T> where T is the row to be written. Each instance of T is then added to a batch and written to the database. The user has little control over how many rows will be added to one batch. If JdbcIO would also support writing a PCollection<Iterable<T>> the user would have more control over the number of rows in one batch. Especially when writing to cloud databases, such as Google Cloud Spanner, the batching of multiple rows together is important for performance.

I already have a solution locally and I will submit a pull request.

Issue Links

• links to: GitHub Pull Request #4457