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