Spark连接MySQL
一、添加依赖jar包
<!--spark支持mysql-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.32</version>
</dependency>
import java.util.Properties
import org.apache.spark.sql.{
DataFrame, SparkSession}
object MysqlDemo extends App {
private val spark: SparkSession = SparkSession.builder().master("local[2]").appName("mysql")
.getOrCreate()
//TODO 配置url,tableName,prop
val url="jdbc:mysql://192.168.95.138:3306/kb10"
val tableName="student"
val prop = new Properties()
prop.setProperty("user","root")
prop.setProperty("password","javakb10")
prop.setProperty("driver","com.mysql.jdbc.Driver")
//TODO spark连接mysql,读取mysql中的表并将其转换成df
val mysqlDF:</