1、MySQL连接
def getConnection()={
Class.forName("com.mysql.jdbc.Driver")
DriverManager.getConnection("jdbc:mysql://192.168.137.130:3306/rzdb?useSSL=false","root","syncdb123!")
}
2、foreachRDD=>foreachPartition=>foreach
先开启natcat
[hadoop@vm01 bin]$ nc -lk 8888
MySQL创建一张表
create table wc(word varchar(20),cnt int(10));
然后按照下面4段代码,依次注释和执行。
package com.ruozedata.spark
import java.sql.DriverManager
import org.apache.spark.SparkConf
import org.apache.spark.streaming.{
Seconds, StreamingContext}
object SocketWCApp {
def main(args: Array[String]): Unit = {
val sparkConf=new SparkConf().setMaster("local[2]").setAppName("SocketWCApp")
val ssc=new StreamingContext(sparkConf,S