[
https://issues.apache.org/jira/browse/SPARK-10946?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15006461#comment-15006461
]
Apache Spark commented on SPARK-10946:
--------------------------------------
User 'somideshmukh' has created a pull request for this issue:
https://github.com/apache/spark/pull/9733
> JDBC - Use Statement.executeUpdate instead of PreparedStatement.executeUpdate
> for DDLs
> --------------------------------------------------------------------------------------
>
> Key: SPARK-10946
> URL: https://issues.apache.org/jira/browse/SPARK-10946
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 1.4.0, 1.4.1, 1.5.1
> Reporter: Pallavi Priyadarshini
> Priority: Minor
>
> Certain DataFrame APIs invoke DDLs such as CREATE TABLE and DROP TABLE under
> the covers. Current code in DataFrameWriter and JDBCUtils uses
> PreparedStatement.executeUpdate to issue the DDLs to the DBs. This causes the
> DDLs to fail against couple of databases that do not support prepares of DDLs.
> Can we use Statement.executeUpdate instead of
> PreparedStatement.executeUpdate? DDL is not a repetitive activity, so there
> shouldn't be a performance impact.
> I can submit a PULL request if no one has objections.
> Thanks.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
