Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.