Fouad Haddud

1

votes
0

answer
215

views

Using JBDC to read sql file in spark scala collecting Warehouse error

I am trying to read MySQL file using Spark Scala. Following is the code I tried val dataframe_mysql = sqlContext.read.format('jdbc') .option('url','jdbc:mysql://xx.xx.xx.xx:xx') .option('driver', 'com.mysql.jdbc.Driver') .option('dbtable', 'schema.xxxx') .option('user', 'xxxx').option('password', '...
Fouad Haddud