Pallavi Priyadarshini created SPARK-10946:
---------------------------------------------
Summary: JDBC - Use Statement.execute instead of
PreparedStatement.execute for DDLs
Key: SPARK-10946
URL: https://issues.apache.org/jira/browse/SPARK-10946
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 1.5.1, 1.4.1, 1.4.0
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: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
