[jira] [Created] (SPARK-12941) Spark cannot write to Oracle when using string data types

["Jose Martinez Poblete (JIRA)" <ji...@apache.org>]

Jose Martinez Poblete created SPARK-12941:
---------------------------------------------

             Summary: Spark cannot write to Oracle when using string data types
                 Key: SPARK-12941
                 URL: https://issues.apache.org/jira/browse/SPARK-12941
             Project: Spark
          Issue Type: Bug
          Components: Spark Core
    Affects Versions: 1.4.1
         Environment: Apache Spark 1.4.2.2
            Reporter: Jose Martinez Poblete


When exporting data from Spark to Oracle, string datatypes are translated to TEXT for Oracle, this is leading to the following error

{noformat}
java.sql.SQLSyntaxErrorException: ORA-00902: invalid datatype
{noformat}

As per the following code:

https://github.com/apache/spark/blob/branch-1.4/sql/core/src/main/scala/org/apache/spark/sql/jdbc/jdbc.scala#L144

See also:

http://stackoverflow.com/questions/31287182/writing-to-oracle-database-using-apache-spark-1-4-0




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