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

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

Asked Jun 19, 2024 Modified Jun 20, 2024
Viewed 53
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-kkk691
answered Jun 19, 2024

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

edited Jun 19, 2024
阿渊@SelectDB (没回帖直接加我主页微信)10485
answered Jun 19, 2024
Related Questions
Flink Connector 26.3.0 读取 DATETIME 变成 1970 年,切换 25.0.0 后正常
1 answers
SelectDB Doris 2.1.8-3 升级使用灵活部分列更新,推荐版本及升级流程咨询
1 answers
max_by会不会忽略null值
1 answers
Apache Doris Dashboard未授权访问漏洞
1 answers
Apache Doris默认口令登录漏洞
Doris2.1.6升级为Doris2.1.11后全部be节点进程频繁停止运行
1 answers

Terms of service Privacy policy

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