Hi, I have the folowing code: val conf = new SparkConf().setAppName("Spark Test") val sc = new SparkContext(conf) val sqlContext = new org.apache.spark.sql.SQLContext(sc)
val data = sqlContext.read.format("jdbc").options( Map( "url" -> "jdbc:sqlite:/nv/pricing/ix_tri_pi.sqlite3", "dbtable" -> "SELECT security_id FROM ix_tri_pi")).load() data.foreach { row => println(row.getInt(1)) } And I try to submit it with: spark-submit \ --class "com.novus.analytics.spark.SparkTest" \ --master "local[4]" \ /Users/smabie/workspace/analytics/analytics-spark/target/scala-2.10/analytics-spark.jar \ --conf spark.executer.extraClassPath=sqlite-jdbc-3.8.7.jar \ --conf spark.driver.extraClassPath=sqlite-jdbc-3.8.7.jar \ --driver-class-path sqlite-jdbc-3.8.7.jar \ --jars sqlite-jdbc-3.8.7.jar But I get the following exception: Exception in thread "main" java.sql.SQLException: No suitable driver I am using Spark version 1.6.1, if that helps. Thanks! Any help would be *greatly* appreciated! -- View this message in context: http://apache-spark-user-list.1001560.n3.nabble.com/Can-t-access-sqlite-db-from-Spark-tp26814.html Sent from the Apache Spark User List mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@spark.apache.org For additional commands, e-mail: user-h...@spark.apache.org