pio导入错误 [英] Error with pio import

问题描述

我可以正常创建应用程序，但是不能导入数据.都不适合进行pio训练和pio部署. 有人可以帮我吗?

I can create application normally, but cannot import data. Neither for pio train and pio deploy. Can anyone help me with that?

[INFO] [App$] Initialized Event Store for this app ID: 1.
[INFO] [App$] Created new app:
[INFO] [App$]       Name: 1
[INFO] [App$]         ID: 1
[INFO] [App$] Access Key:     v9gaJRl8AD4iL1mEvaZuJ8swaLiAEqVUzWdXlVkkCnbKKBMFSBljIq5dZ02JaAkL
Exception in thread "main" java.sql.SQLException: No suitable driver found for jdbc:mysql://192.168.1.30/recommend_361
at java.sql.DriverManager.getConnection(DriverManager.java:596)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:75)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1148)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
at scalikejdbc.CommonsConnectionPool.borrow(CommonsConnectionPool.scala:43)
at scalikejdbc.DB$.autoCommit(DB.scala:214)
at io.prediction.data.storage.jdbc.JDBCChannels.<init>(JDBCChannels.scala:29)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at io.prediction.data.storage.Storage$.getDataObject(Storage.scala:303)
at io.prediction.data.storage.Storage$.getDataObjectFromRepo(Storage.scala:263)
at io.prediction.data.storage.Storage$.getMetaDataChannels(Storage.scala:376)
at io.prediction.tools.imprt.FileToEvents$$anonfun$main$1.apply(FileToEvents.scala:65)
at io.prediction.tools.imprt.FileToEvents$$anonfun$main$1.apply(FileToEvents.scala:63)
at scala.Option.map(Option.scala:145)
at io.prediction.tools.imprt.FileToEvents$.main(FileToEvents.scala:63)
at io.prediction.tools.imprt.FileToEvents.main(FileToEvents.scala)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.apache.spark.deploy.SparkSubmit$.org$apache$spark$deploy$SparkSubmit$$runMain(SparkSubmit.scala:672)
at org.apache.spark.deploy.SparkSubmit$.doRunMain$1(SparkSubmit.scala:180)
at org.apache.spark.deploy.SparkSubmit$.submit(SparkSubmit.scala:205)
at org.apache.spark.deploy.SparkSubmit$.main(SparkSubmit.scala:120)
at org.apache.spark.deploy.SparkSubmit.main(SparkSubmit.scala)

非常感谢您.

推荐答案

您需要使驱动程序jar文件对驱动程序可用，因此运行

You need to make the driver jar file available to the driver so run

pio import --appid <appId> --input </path/to/json_file> -- --driver-class-path </path/to/mysql-connector-java.jar>

这篇关于pio导入错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！