如何使用Spark2.4.0中的PySpark接口将表插入配置单元

from pyspark.sql import SparkSession
from pyspark.sql.types import StructType, StructField, StringType

spark = SparkSession.builder.appName("InsertIntoConfigUnit").getOrCreate()

schema = StructType([
    StructField("column1", StringType(), True),
    StructField("column2", StringType(), True),
    ...
])

data = [("value1", "value2", ...), ("value3", "value4", ...), ...]
df = spark.createDataFrame(data, schema)

df.write.format("jdbc").options(
    url="jdbc:mysql://hostname:port/database",
    driver="com.mysql.jdbc.Driver",
    dbtable="config_unit",
    user="username",
    password="password"
).mode("append").save()