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

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

Asked Jun 19, 2024 Modified Jun 20, 2024
Viewed 44
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
阿渊@SelectDB (没回帖直接加我主页微信)8885
answered Jun 19, 2024
Related Questions
doris2.1.7 truncate table xxx 及 create table 报错,faied to find enugh backend
1 answers
flinksql写Doris标记删除时'sink.enable-delete' = 'false'的含义
1 answers
doris无法对包含.的文本进行分词
1 answers
2.1.0 BE OOM,内存分析求助
1 answers
doris be节点会不定期在凌晨02:00 崩溃
1 answers
经常出现查询超时问题 P99 查询延迟特别高
1 answers

Terms of service Privacy policy

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