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-kkk656
answered Jun 19, 2024

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

edited Jun 19, 2024
阿渊@SelectDB6795
answered Jun 19, 2024
Related Questions
bitmap精确去重 效率不如distinct?
[CANCELLED]failed to initialize storage reader. tablet=57732, res=[E-3110][INTERNAL_ERROR]different type between schema and column reader
跪求大佬指导一下,doris be节点其中一个磁盘故障后更换新磁盘后无法重启be服务
1 answers
Spark读取Doris报错
1 answers
doris报错被截断 doris版本2.1.6
1 answers
doris 偶发查询很慢

Terms of service Privacy policy

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