JDBC Connection String
MySQL
"url" -> "jdbc:mysql://Host/DBName?user=UserName&password=UserPassword" "driver" -> "com.mysql.jdbc.Driver" "dbtable" -> "TableName"
MongoDB
sqlContext.read.format("com.mongodb.spark.sql") .options(Map("uri" -> "mongodb://Host/DBName", "collection" -> "TableName"))
Oracle
"url" -> "jdbc:oracle:thin:UserName/UserPassword@Host:Port:SIDName", "driver" -> "oracle.jdbc.driver.OracleDriver", "dbtable" -> "TableName")
Last updated
Was this helpful?