一、spark连mysql
1、先添加依赖
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.32</version>
</dependency>
2、代码如下:
import java.util.Properties
import org.apache.spark.SparkContext
import org.apache.spark.sql.{
DataFrame, SparkSession}
object ConnectMysql {
def main(args: Array[String]): Unit = {
val spark: SparkSession = SparkSession.builder()
.master("local[4]")
.appName(this.getClass.getName)
.getOrCreate()
val sc: SparkContext = spark.sparkContext
import spark.implicits._
//" IP_ADDRESS : PORT " 处,输入对应的虚机的IP地址及端口号
//" DATABASE " 处,输入对应的数据库
//设置要访问的mysql的url,表名
val url = "jdbc:mysql://IP_ADDRESS : PORT/DATABASE"
//" TABLE_NAME " 处,输入对应的数据库
val tableName = " TABLE_NAME "
val props = new Properties()