Hi Kuli, Can you try providing the driver path as a Spark pass-through argument, with `pio import -- --driver-class-path xx.jar`?
Chan On Fri, Nov 25, 2016 at 1:41 AM, Kuli Gábor <[email protected]> wrote: > Hi All, > please help me! > > I would like to run PredictionIO Text Classification Engine i followed > this tutorial: > > http://predictionio.incubator.apache.org/demo/textclassification/ > > I create my app, it's up and running, I can see when I run this command: > > pio app list > > Then I try to run this command: > > pio import --appid 2 --input data/stopwords.json > > But I've got this error message: > > Exception in thread "main" java.sql.SQLException: No suitable driver > at java.sql.DriverManager.getDriver(DriverManager.java:315) > at org.apache.spark.sql.execution.datasources.jdbc. > JdbcUtils$$anonfun$2.apply(JdbcUtils.scala:50) > at org.apache.spark.sql.execution.datasources.jdbc. > JdbcUtils$$anonfun$2.apply(JdbcUtils.scala:50) > at scala.Option.getOrElse(Option.scala:120) > at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$. > createConnectionFactory(JdbcUtils.scala:49) > at org.apache.spark.sql.DataFrameWriter.jdbc( > DataFrameWriter.scala:278) > at org.apache.predictionio.data.storage.jdbc.JDBCPEvents. > write(JDBCPEvents.scala:162) > at org.apache.predictionio.tools.imprt.FileToEvents$$anonfun$ > main$1.apply(FileToEvents.scala:101) > at org.apache.predictionio.tools.imprt.FileToEvents$$anonfun$ > main$1.apply(FileToEvents.scala:68) > at scala.Option.map(Option.scala:145) > at org.apache.predictionio.tools.imprt.FileToEvents$.main( > FileToEvents.scala:68) > at org.apache.predictionio.tools.imprt.FileToEvents.main( > FileToEvents.scala) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke( > NativeMethodAccessorImpl.java:62) > at sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at org.apache.spark.deploy.SparkSubmit$.org$apache$spark$ > deploy$SparkSubmit$$runMain(SparkSubmit.scala:731) > at org.apache.spark.deploy.SparkSubmit$.doRunMain$1( > SparkSubmit.scala:181) > at org.apache.spark.deploy.SparkSubmit$.submit( > SparkSubmit.scala:206) > at org.apache.spark.deploy.SparkSubmit$.main(SparkSubmit. > scala:121) > at org.apache.spark.deploy.SparkSubmit.main(SparkSubmit.scala) > > Can anybody help me what kind of driver should I use? In my > `spark-defaults.conf` I only put this dirver: > > spark.driver.extraClassPath /home/kebodev/ojdbc/ojdbc6.jar > > What else driver should I put to my `spark-defaults.conf` > > Thank you for help me! > > >
