spark-sql启动报错

问题：

spark-sql启动报错信息如下：

Caused by: java.sql.SQLException: No suitable driver found for jdbc:mysql://lee000:3306/hadoop_hive?createDatabaseIfNotExsit=true
	at java.sql.DriverManager.getConnection(DriverManager.java:689)
	at java.sql.DriverManager.getConnection(DriverManager.java:208)
	at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:361)
	at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:416)
	... 66 more

解决方案：

这是因为没有指定"--driver-class-path"路径参数导致，正确的启动方式应该如下：

./spark-sql --master local[2] --jars /root/study/spark/software/mysql-connector-java-5.1.30.jar --driver-class-path /root/study/spark/software/mysql-connector-java-5.1.30.jar