[
https://issues.apache.org/jira/browse/FLINK-18640?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17161018#comment-17161018
]
Leonard Xu commented on FLINK-18640:
------------------------------------
Hi，[~良]
{quote}
The quote need to deal with the database reserved words. But we should quote
it like "ods"."t_test", not "ods.t_test".
{quote}
I get your point, we need to deal schema for PG, PG table's path is a little
special which contains four levels like
`catalogName`.`dbName`.`schemaName`.`tableName`, but we only considered three
levels for catalog table path
in Flink i.e. `catalogName`.`dbName`.`tableName`, this should be a general
issue for Flink JDBC table/catalog.
> Flink jdbc not support postgresql with schema
> ---------------------------------------------
>
> Key: FLINK-18640
> URL: https://issues.apache.org/jira/browse/FLINK-18640
> Project: Flink
> Issue Type: Bug
> Components: Connectors / JDBC
> Affects Versions: 1.9.1, 1.10.1
> Reporter: 毛宗良
> Priority: Major
>
> Flink jdbc throw exceptions when read a postgresql table with scheam, like
> "ods.t_test". BY debugging the source code, I found a bug about dealing the
> table name.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
