[jira] [Comment Edited] (SPARK-8008) JDBC data source can overload the external database system due to high concurrency

["Reynold Xin (JIRA)" <ji...@apache.org>]

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

Reynold Xin edited comment on SPARK-8008 at 6/3/15 8:08 AM:
------------------------------------------------------------

[~rtreffer] can you submit a patch to the jdbc data source write to throttle there using your union hack?

I think it's easy to throttle write, but pretty hard to throttle reads in all places.



was (Author: rxin):
[~rtreffer] can you submit a patch to the jdbc data source write to throttle there using your union hack?

> JDBC data source can overload the external database system due to high concurrency
> ----------------------------------------------------------------------------------
>
>                 Key: SPARK-8008
>                 URL: https://issues.apache.org/jira/browse/SPARK-8008
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>            Reporter: Rene Treffer
>
> Spark tries to load as many partitions as possible in parallel, which can in turn overload the database although it would be possible to load all partitions given a lower concurrency.
> It would be nice to either limit the maximum concurrency or to at least warn about this behavior.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org