Bemærk
Adgang til denne side kræver godkendelse. Du kan prøve at logge på eller ændre mapper.
Adgang til denne side kræver godkendelse. Du kan prøve at ændre mapper.
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.