[jira] [Created] (FLINK-21820) JDBC connector shouldn't read all rows in per statement by default

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (FLINK-21820) JDBC connector shouldn't read all rows in per statement by default

Shang Yuanchun (Jira)
Leonard Xu created FLINK-21820:
----------------------------------

             Summary: JDBC connector shouldn't read all rows in per statement by default
                 Key: FLINK-21820
                 URL: https://issues.apache.org/jira/browse/FLINK-21820
             Project: Flink
          Issue Type: Improvement
          Components: Connectors / JDBC
            Reporter: Leonard Xu


The default value for JDBC option 'scan.fetch-size' is 0 which means read all rows in statement, this may lead to OOM or IO timeout.

We'd better set a reasonable value as default value.

 

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)
Reply | Threaded
Open this post in threaded view
|

Re: [jira] [Created] (FLINK-21820) JDBC connector shouldn't read all rows in per statement by default

ding peng
unsubscribe

Leonard Xu (Jira) <[hidden email]> 于2021年3月16日周二 下午8:05写道:

> Leonard Xu created FLINK-21820:
> ----------------------------------
>
>              Summary: JDBC connector shouldn't read all rows in per
> statement by default
>                  Key: FLINK-21820
>                  URL: https://issues.apache.org/jira/browse/FLINK-21820
>              Project: Flink
>           Issue Type: Improvement
>           Components: Connectors / JDBC
>             Reporter: Leonard Xu
>
>
> The default value for JDBC option 'scan.fetch-size' is 0 which means read
> all rows in statement, this may lead to OOM or IO timeout.
>
> We'd better set a reasonable value as default value.
>
>
>
>
>
>
>
> --
> This message was sent by Atlassian Jira
> (v8.3.4#803005)
>