Has anyone using Spark 1.6.2 encountered very slow responses from pulling data from PostgreSQL using JDBC? I can get to the table and see the schema, but when I do a show, it takes very long or keeps timing out.
The code is simple. val jdbcDF = sqlContext.read.format("jdbc").options( Map("url" -> "jdbc:postgresql://dbserver:port/database?user=user&password=password", "dbtable" -> “schema.table")).load() jdbcDF.show If anyone can help, please let me know. Thanks, Ben