Artem Kupchinskiy created SPARK-38116:
-----------------------------------------
Summary: Ability to turn off auto commit in JDBC source for read
only operations
Key: SPARK-38116
URL: https://issues.apache.org/jira/browse/SPARK-38116
Project: Spark
Issue Type: Improvement
Components: SQL
Affects Versions: 3.2.1
Reporter: Artem Kupchinskiy
Currently, all the jdbc connections on executors side work always with auto
commit option set to true.
However, there are cases where this mode makes hard to use JdbcRelationProvider
at all, i.e. reading huge datasets from Postgres (a whole result set is
collected regardless of a fetch size when autocommit is set to true
https://jdbc.postgresql.org/documentation/91/query.html#query-with-cursor )
So the proposal is following:
# Add a boolean option "autocommit" to JDBC Source allowing a user to turn off
autocommit mode for read only operations.
# Add guards which prevent using this option in DML operations.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
