Dongjoon Hyun created SPARK-16463:
-------------------------------------
Summary: Support `truncate` option in Overwrite mode for JDBC
DataFrameWriter
Key: SPARK-16463
URL: https://issues.apache.org/jira/browse/SPARK-16463
Project: Spark
Issue Type: Improvement
Reporter: Dongjoon Hyun
Priority: Minor
This issue adds a boolean option, `truncate`, for SaveMode.Overwrite of JDBC
DataFrameWriter. If this option is `true`, it use `TRUNCATE TABLE` instead of
`DROP TABLE`.
- Without CREATE/DROP privilege, we can save dataframe to database. Sometime
these are not allowed for security.
- It will keep the existing table information, so users can add and keep some
additional CONSTRAINTs for the table.
- Sometime, TRUNCATE is faster than the combination of DROP/CREATE.
This issue is different from SPARK-16410 which aims to use `TRUNCATE` only for
JDBC sources.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
