def main(args: Array[String]): Unit = {
//spark SparkSession对象 操作sql语句
val spark = SparkSession.builder().config(conf).getOrCreate()
val sc = spark.sparkContext
import spark.implicits._
//jdbc
val prop = new Properties()
prop.put("user","root")
prop.put("password","root")
//创建链接读取
val df = spark.read.jdbc("jdbc:mysql://localhost:3306/数据库","user",prop)
df.show()
sparksql之JDBC支持
最新推荐文章于 2024-06-01 08:50:02 发布