mysql数据库关闭连接spark_Spark-SQL连接MySql关系型数据库

完整程序如下：

package com.ckm.spark.sql

import java.util.Properties

import org.apache.spark.sql.SQLContext

import org.apache.spark.{SparkContext, SparkConf}

/**

* Created by ckm on 2016/9/26.

*/

object SelectFromOneTable {

def main(args: Array[String]) {

val sparkConf = new SparkConf().setAppName("Spark SQL Test Case").setMaster("local[2]")

val sparkContext = new SparkContext(sparkConf)

val sqlContext = new SQLContext(sparkContext)

val properties = new Properties()

val url = "jdbc:mysql://m000:3306/test"

val jdbcDF = sqlContext.read.format("jdbc").options(

Map("url" -> url,

"user" -> "root",

"password" -> "root",

"dbtable" -> "spark_sql_test1")).load()

jdbcDF.registerTempTable("test1")

sqlContext.sql("select * from test1 where id > 10").collect().take(10).foreach(println)

}

}