databricks spark 读取postgresql表

1、来上货

driver = "org.postgresql.Driver"
url = "jdbc:postgresql://dbservice-url:port/库名"
user = "csl"
password = "******"

# 读取
jdbcDF3 = spark.read.format("jdbc") \
    .option("driver", driver)\
    .option("url", url) \
    .option("user", user) \
    .option("password", password) \
    .option("query","select * from arch_aclass") \
    .option('fetchsize',"1000") \
    .load()

display(jdbcDF3)
```![在这里插入图片描述](https://img-blog.csdnimg.cn/33d2f29cd3c346ed8cc8f4d4a8f579b4.png)