Spark连接MySQL，Hive，Hbase

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: DataFrame =