search

databricks / Spark-The-Definitive-Guide

Spark: The Definitive Guide's Code Repository
http://shop.oreilly.com/product/0636920034957.do
Other
2.85k stars 2.76k forks source link

Chapter 9: java.lang.ClassNotFoundException: org.sqllite.JDBC #56

Closed arunprasadbh closed 4 years ago

arunprasadbh commented 4 years ago

Hi I am trying to use sqllite to create Data frame. Below is the code. _

driver = "org.sqllite.JDBC" path = "/dbfs/databricks-datasets/definitive-guide/data/flight-data/jdbc/my-sqlite.db" url = "jdbc:sqllite:" + path table_name = "flight_info"

dfDF = spark.read.format("jdbc").option("url", url) \ .option("dbtable", tablename) \ .option("driver", driver) \ .load()

I am getting error class not found: java.lang.ClassNotFoundException: org.sqllite.JDBC on line that has driver option.

Is it possible to run JDBC code on community edition? please let me know what I need to do sort this error.

arunprasadbh commented 4 years ago

typo in sqllite causing this issue. please ignore.

arunprasadbh commented 4 years ago

typo in sqllite causing this issue. please ignore.