beam-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Eugene Kirpichov (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (BEAM-1323) Add parallelism/splitting in JdbcIO
Date Tue, 01 Aug 2017 19:00:03 GMT

    [ 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)

Mime
View raw message