[
https://issues.apache.org/jira/browse/BEAM-1323?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16109527#comment-16109527
]
Eugene Kirpichov commented on BEAM-1323:
----------------------------------------
This may be addressed by creating JdbcIO.readAll() that takes a PCollection of
queries (or more like, a parameterized query with a PCollection of parameters).
Then the user can create a PCollection of queries reading arbitrarily specified
partitions of the database. I doubt that we'll be able to come up with an
easier-to-use interface for partitioning of JdbcIO.read() than this explicit
partitioning via readAll().
> Add parallelism/splitting in JdbcIO
> -----------------------------------
>
> Key: BEAM-1323
> URL: https://issues.apache.org/jira/browse/BEAM-1323
> Project: Beam
> Issue Type: Improvement
> Components: sdk-java-extensions
> Reporter: Jean-Baptiste Onofré
> Assignee: Jean-Baptiste Onofré
>
> Now, the JDBC IO is basically a {{DoFn}} executed with a {{ParDo}}. So, it
> means that parallelism is "limited" and executed on one executor.
> We can imagine to create several JDBC {{BoundedSource}}s splitting the SQL
> query in subset (for instance using row id paging or any "splitting/limit"
> we can figure based on the original SQL query) (something similar to what
> Sqoop is doing).
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
