问题:
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