Re: sqlcontext - not able to connect to database

2016-06-14 Thread Jeff Zhang
The jdbc driver jar is not on classpath, please add it using --jars On Wed, Jun 15, 2016 at 12:45 PM, Tejaswini Buche < tejaswini.buche0...@gmail.com> wrote: > hi, > > I am trying to connect to a mysql database on my machine. > But, I am getting some error > > dataframe_mysql =

sqlcontext - not able to connect to database

2016-06-14 Thread Tejaswini Buche
hi, I am trying to connect to a mysql database on my machine. But, I am getting some error dataframe_mysql = sqlContext.read.format("jdbc").options( url="jdbc:mysql://localhost:3306/my_db", driver = "com.mysql.jdbc.Driver", dbtable = "data1", user="123").load() below is the