Load Multiple DB Table - Spark SQL

[Ashish Soni]

Hi All ,

What is the best possible way to load multiple data tables using spark sql

Map<String, String> options = new HashMap<>();
options.put("driver", MYSQLDR);
options.put("url", MYSQL_CN_URL);
options.put("dbtable","(select * from courses);




*can i add multiple tables to options map options.put("dbtable1","(select *
from test1);options.put("dbtable2","(select * from test2);*


DataFrame jdbcDF = sqlContext.load("jdbc", options);


Thanks,
Ashish