beam-commits mailing list archives

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


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
than this explicit partitioning via readAll().

> Add parallelism/splitting in JdbcIO
> -----------------------------------
>                 Key: BEAM-1323
>                 URL:
>             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

View raw message