Fouad Haddud
1 questions
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', '...