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

• Type: Improvement
• Status: Open
• Priority: Not a Priority
• Resolution: Unresolved
• Component/s: Connectors / JDBC, Table SQL / Ecosystem
• Labels: auto-deprioritized-major auto-deprioritized-minor
• Assignee: Unassigned
• Reporter: Leonard Xu
• Created: 16/Mar/21 12:04
• Updated: 24/Nov/21 10:43

Description

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.