转自:http://blog.csdn.net/liuzongxi/article/details/51764104
1. 引入mysql的驱动包到/usr/local/spark/spark-1.6.0-bin-hadoop2.6/lib/Hbase(目录根据配置而不同)
mysql-connector-Java-5.1.7-bin.jar
并在mysql创建表stock:
CREATE TABLE `stock` (
`id` decimal(20,0) DEFAULT NULL,
`stock_code` varchar(20) DEFAULT NULL,
`stock_cname` varchar(50) DEFAULT NULL,
`stock_ename` varchar(50) DEFAULT NULL,
`mark` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2.scala程序
package com.wonhigh.test
import java.sql.DriverManager
import org.apache.spark.SparkContext
import org.apache.spark.rdd.JdbcRDD
import org.apache.spark.SparkConf
import org.apache.spark.sql.SQLContext
import java.util.Properties
object SparkOnMysql {
def main(args: Ar