Github user dongjoon-hyun commented on a diff in the pull request:
https://github.com/apache/spark/pull/19911#discussion_r155328166
--- Diff:
sql/core/src/main/scala/org/apache/spark/sql/jdbc/PostgresDialect.scala ---
@@ -100,5 +100,5 @@ private object PostgresDialect extends JdbcDialect {
}
- override def isCascadingTruncateTable(): Option[Boolean] = Some(true)
+ override def isCascadingTruncateTable(): Option[Boolean] = Some(false)
--- End diff --
@bolkedebruin .
Originally, Spark uses `DROP TABLE` for Overwrite mode. #14086 introduced
`TRUNCATE` operation when `JdbcUtils.isCascadingTruncateTable(url) ==
Some(false)`.
So, for PostgresDialect, Spark doesn't use TRUNCATE here.
---
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
