如何使用pyspark读取包含多行的.sql文件？

from pyspark.sql import SparkSession

spark = SparkSession.builder.appName("Read SQL File").getOrCreate()

df = spark.read.text("path/to/file.sql")

df = df.withColumn("split_col", split(df["value"], ";"))

df = df.withColumn("exploded_col", explode(df["split_col"]))

df.createOrReplaceTempView("temp_view")

result = spark.sql("SELECT * FROM temp_view")

from pyspark.sql import SparkSession
from pyspark.sql.functions import split, explode

spark = SparkSession.builder.appName("Read SQL File").getOrCreate()

df = spark.read.text("path/to/file.sql")
df = df.withColumn("split_col", split(df["value"], ";"))
df = df.withColumn("exploded_col", explode(df["split_col"]))
df.createOrReplaceTempView("temp_view")
result = spark.sql("SELECT * FROM temp_view")

result.show()