Return-Path: X-Original-To: apmail-spark-issues-archive@minotaur.apache.org Delivered-To: apmail-spark-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 18C0A172CB for ; Tue, 6 Oct 2015 06:33:33 +0000 (UTC) Received: (qmail 50089 invoked by uid 500); 6 Oct 2015 06:33:26 -0000 Delivered-To: apmail-spark-issues-archive@spark.apache.org Received: (qmail 50056 invoked by uid 500); 6 Oct 2015 06:33:26 -0000 Mailing-List: contact issues-help@spark.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Delivered-To: mailing list issues@spark.apache.org Received: (qmail 50046 invoked by uid 99); 6 Oct 2015 06:33:26 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 06 Oct 2015 06:33:26 +0000 Date: Tue, 6 Oct 2015 06:33:26 +0000 (UTC) From: "Pallavi Priyadarshini (JIRA)" To: issues@spark.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (SPARK-10946) JDBC - Use Statement.execute instead of PreparedStatement.execute for DDLs MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 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-unsubscribe@spark.apache.org For additional commands, e-mail: issues-help@spark.apache.org