Advertisement
Guest User

Untitled

a guest
Aug 19th, 2017
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.28 KB | None | 0 0
  1. %spark
  2. val opts = Map(
  3. "url" -> "jdbc:postgresql://172.17.0.2:5432/openflights",
  4. "driver" -> "org.postgresql.Driver",
  5. "user" -> "postgres",
  6. "password" -> "postgres",
  7. "dbtable" -> "countries")
  8.  
  9. val countriesDf = sqlContext.read.format("jdbc").options(opts).load()
  10. countriesDf.show
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement