spark-sql无法启动，但是spark-shell没问题

Question

NestedThrowables:
java.sql.SQLException: Unable to open a test connection to the given database. JDBC url = jdbc:mysql://47.105.104.208:3306/sparksql?createDatabaseIfNotExist=true, username = root. Terminating connection pool (set lazyInit to true if you expect to start your database after your app). Original Exception: ------
java.sql.SQLException: No suitable driver found for jdbc:mysql://47.105.104.208:3306/sparksql?createDatabaseIfNotExist=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.(BoneCP.java:416)
at com.jolbox.bonecp.BoneCPDataSource.getConnection(BoneCPDataSource.java:120)
at org.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getConnection(ConnectionFactoryImpl.java:501)
at org.datanucleus.store.rdbms.RDBMSStoreManager.(RDBMSStoreManager.java:298)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

驱动没问题啊 因为spark–shell可以启动

Answer 1

Michael_PK 2019-08-06 17:50:17

你的启动脚本咋写的？MySQL数据库是否具备机器的远程访问权限？驱动版本是多少

• 提问者 weixin_慕设计2423553 #1

  1../spark-sql --master 'local[2]' --jars /data/mysql-connector-java-5.1.47-bin.jar
  2.mysql-connector-java-5.1.47-bin.jar
  3.mysql具有远程权限 版本为5.7.27 （虽然和驱动版本不一样 但是spark-shell可以启动
  ）

• 提问者 weixin_慕设计2423553 #2

  1../spark-sql --master 'local[2]' --jars /data/mysql-connector-java-5.1.47-bin.jar 
  2.mysql-connector-java-5.1.47-bin.jar 
  3.mysql具有远程权限 版本为5.7.27 （虽然和驱动版本不一样 但是spark-shell可以启动 ）

• Michael_PK #3

  jar s还不够，还需要加一个driver path啥的那个参数，通过help查看下