Del via


jdbc (DataFrameWriter)

Saves the content of the DataFrame to an external database table via JDBC.

Syntax

jdbc(url, table, mode=None, properties=None)

Parameters

Parameter Type Description
url str The JDBC URL of the form jdbc:subprotocol:subname.
table str The name of the table in the external database.
mode str, optional The behavior when data already exists. Accepted values are 'append', 'overwrite', 'ignore', and 'error' or 'errorifexists' (default).
properties dict, optional A dictionary of JDBC database connection arguments. Typically includes 'user' and 'password', for example {'user': 'SYSTEM', 'password': 'mypassword'}.

Returns

None

Notes

Avoid creating too many partitions in parallel on a large cluster, as this can crash external database systems.