Apache Drill无法连接PostgreSQL，求助排查配置问题

云上老周

2026-7-6

Apache Drill连接PostgreSQL配置问题

配置与启动操作

我尝试通过以下配置让Apache Drill连接PostgreSQL数据库：

storage-plugins-override.conf 配置内容：

"postgresql": {
      "type": "jdbc",
      "driver": "org.postgresql.Driver",
      "url": "${POSTGRES_URL}",
      "username": "${POSTGRES_USER}",
      "password": "${POSTGRES_PASSWORD}",
      "enabled": true,
      "sourceParameters": {
        "minimumIdle": 0,
        "autoCommit": true,
        "connectionTestQuery": "select version() as postgresql_version",
        "dataSource.cachePrepStmts": true,
        "dataSource.prepStmtCacheSize": 250
      }

执行Docker命令启动Apache Drill：

docker run -it --name drill -p 8048:8047 -p 31011:31010 \
  -e GCS_KEY_FILE -e DATA_PATH -e POSTGRES_URL -e POSTGRES_USER -e POSTGRES_PASSWORD \
  -v /home/indio/drill/bq:/tmp/data \
  -v /home/indio/drill/drill-override.conf:/opt/drill/conf/drill-override.conf \
  -v /home/indio/drill/storage-plugins-override.conf:/opt/drill/conf/storage-plugins-override.conf \
  -v /home/indio/drill/postgres-sample-data:/opt/drill/sample-data/postgres \
  -v /home/indio/drill/postgresql-42.6.0.jar:/opt/drill/jars/3rdparty/postgresql-42.6.0.jar \
  apache/drill \
  /opt/drill/bin/sqlline -u "jdbc:drill:zk=local" -n admin -p admin

其中postgresql-42.6.0.jar是按照Apache Drill官方文档说明下载的。

遇到的问题

执行SHOW SCHEMAS命令未显示postgresql相关模式，执行use pgdb时提示Schema无效：

apache drill> SHOW SCHEMAS;
+--------------------+
|    SCHEMA_NAME     |
+--------------------+
| dfs.default        |
| dfs.root           |
| dfs.tmp            |
| information_schema |
| sys                |
| cp.default         |
+--------------------+
6 rows selected (0.104 seconds)

apache drill> use pgdb;
Error: VALIDATION ERROR: Schema [pgdb] is not valid with respect to either root schema or current default schema.

Current default schema: No default schema selected

[Error Id: 3fffb76d-92f8-4c17-97e7-1d5f022a9ee1 ] (state=,code=0)
apache drill>