Apache Doris 中文技术论坛
Questions Tags Users Badges

【已解决】Doris jdbc连接postgresql查询表数据出错

Asked Jun 19, 2024 Modified Jun 20, 2024
Viewed 38
2.1 query

image.png
可以查到这个表,但是查询的时候报错。

edited Jun 20, 2024
zzxiaoma33
asked Jun 19, 2024
2 Answers
select * from jdbc_postgresql_test.public.`order`

order 是关键字,查询的时候加上转义符

edited Jun 19, 2024
zy-kkk666
answered Jun 19, 2024

感觉是层级映射可能有问题,switch catalog; show databases; 能看到对应的schema吗
image.png

edited Jun 19, 2024
阿渊@SelectDB7915
answered Jun 19, 2024
Related Questions
Doris 2.1.10 执行 Delete 删除命令时不支持 IPv4-mapped IPv6地址
admin_priv都能干哪些事?
doris冷热分层存储问题
升级 Doris 版本后,audit_log表结构如何变更
1 answers
Doris-2.1.8 ALTER TABLE修改字段长度报错
2 answers
BE配置项描述在哪看?

Terms of service Privacy policy

Powered by Answer - the open-source software that powers Q&A communities.
Made with love © 2025 Apache Doris 中文技术论坛.