[jira] [Updated] (SPARK-16968) Allow to add additional options when creating a new table in DF's JDBC writer.

["Sean Owen (JIRA)" <ji...@apache.org>]

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

Sean Owen updated SPARK-16968:
------------------------------
    Priority: Minor  (was: Major)

This is bordering on out of scope for Spark, but may still have some value, to be able to simply and generically pass some metadata. The alternative is to not have Spark make the table if you need more control, of course. I'd also recommend that.

> Allow to add additional options when creating a new table in DF's JDBC writer. 
> -------------------------------------------------------------------------------
>
>                 Key: SPARK-16968
>                 URL: https://issues.apache.org/jira/browse/SPARK-16968
>             Project: Spark
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 2.0.0
>            Reporter: Jie Huang
>            Priority: Minor
>
> We met some problem when trying to export Dataframe to external mysql thru JDBC driver (if the table doesn't exist). In general, Spark will create a new table automatically if it doesn't exist. However it doesn't support to add additional options when creating a new table. 
> For example, we need to set the default "CHARSET=utf-8" in some customer's table. Otherwise, some UTF-8 columns cannot be exported to mysql successfully. Some encoding exception will be thrown and finally break the job.  



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