You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@beam.apache.org by "Anuj Jamwal (JIRA)" <ji...@apache.org> on 2017/08/01 11:05:00 UTC

[jira] [Commented] (BEAM-1323) Add parallelism/splitting in JdbcIO

    [ https://issues.apache.org/jira/browse/BEAM-1323?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16108720#comment-16108720 ] 

Anuj Jamwal commented on BEAM-1323:
-----------------------------------

If i understand correctly, what Jean is implying is that, we can have user specify the column / criterion to create buckets and then we can open multiple connections to database and fetch data in parallel.

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