spark版本:spark-2.1.0-bin-without-hadoop
https://pan.baidu.com/s/19zj-cSPP6ZalwKojKTh7gQ 提取码:sbf7
(参考大数据基础编程、实验和案例教程-林子雨)
#安装spark
#安装mysql驱动程序(以便顺利连接MySQL数据库)
到MySQL官网下载版本:mysql-connector-java-5.1.49.zip
将压缩包放到~/Downloads目录下
cd ~/Downloads
unzip mysql-connector-java-5.1.49.zip
cp ./mysql-connector-java-5.1.49/mysql-connector-java-5.1.49-bin.jar /usr/local/spark/jars
#启动spark-shell交互环境,并指定MySQL连接驱动jar包
在spark-shell中顺序执行如下命令:
/usr/local/spark/jars/mysql-connector-java-5.1.49-bin.jar \
--driver-class-path \
/usr/local/spark/jars/mysql-connector-java-5.1.49-bin.jar
执行完成后即可在spark-shell中读写MySQL数据库