spark-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Reynold Xin (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (SPARK-11881) [SQL] JDBC Postgres fetchsize parameter ignored
Date Fri, 27 Nov 2015 03:12:11 GMT

     [ https://issues.apache.org/jira/browse/SPARK-11881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Reynold Xin resolved SPARK-11881.
---------------------------------
       Resolution: Fixed
         Assignee: Marius Van Niekerk
    Fix Version/s: 1.6.0

> [SQL] JDBC Postgres fetchsize parameter ignored 
> ------------------------------------------------
>
>                 Key: SPARK-11881
>                 URL: https://issues.apache.org/jira/browse/SPARK-11881
>             Project: Spark
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 1.6.0
>            Reporter: Marius Van Niekerk
>            Assignee: Marius Van Niekerk
>             Fix For: 1.6.0
>
>
> Reference: https://jdbc.postgresql.org/documentation/head/query.html#query-with-cursor
> In order for PostgreSQL to honor the fetchSize non-zero setting, its Connection.autoCommit
needs to be set to false. Otherwise, it will just quietly ignore the fetchSize setting. 
> Since the JDBC driver doesn’t serialize the result data in its memory, we don’t want
to have 2-3 times of the memory created in the driver first before Spark can fetch anything
into its serialized data storage. 



--
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


Mime
View raw message