Advertisement
Guest User

Untitled

a guest
Feb 11th, 2016
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. import java.sql.Connection;
  2. import java.sql.DriverManager;
  3. import java.sql.SQLException;
  4.  
  5. Class.forName(“com.mysql.jdbc.Driver”).newInstance()
  6. val DB_URL = “jdbc:mysql://yourhost.com/yourdatabase?user=SomeUsername&password=SomePassword”
  7. csqlc.setKeyspace(“analytics”)
  8.  
  9. csqlc.read.format(“jdbc”).options(
  10. Map(“driver” -> “com.mysql.jdbc.Driver”,
  11. “url” -> DB_URL,
  12. “dbtable” -> “yourdatabase.users”)
  13. ).load().registerTempTable(“analytics_users”)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement