程序为:
import org.apache.spark.sql.SparkSession
object import_data {
def main(args: Array[String]): Unit = {
val spark = SparkSession .builder()
.appName("MysqlDemo")
.master("local").getOrCreate()
val jdbcDF = spark.read.format("jdbc")
.option("delimiter", ",")
.option("heard", true)
.option("url", "jdbc:mysql://ip:xxxx/test?useUnicode=true&characterEncoding=utf-8")
.option("dbtable", "temp")
.option("user", "root").option("password", "123").load()
val res=jdbcDF.write.format("csv").option("delimiter", ",")
.option("heard", true).save("hdfs://ip:xxxx/a.txt")
}
}