Doris版本:3.0.8
GaussDB 数据库模式:M模式
jdbc驱动:Gauss提供的兼容postgre协议的 gsjdbc4.jar
创建catalog如下:
CREATE CATALOG contract_60000007 properties(
'type' = 'jdbc',
'user' = 'rdsmom',
'password' = 'Smc@z9w6',
'jdbc_url' = 'jdbc:postgresql://10.202.99.100:8017/contract_60000007',
'driver_url' = 'gsjdbc4.jar',
'driver_class' = 'org.postgresql.Driver',
"lower_case_meta_names"="true"
);
执行SQL:
select id from contract_60000007.contract_60000007.flhg_authorization_audit
返回报错信息:
[INTERNAL_ERROR]GetJniExceptionMsg meet error, query=SELECT "id" FROM "contract_60000007"."flhg_authorization_audit", msg=[RUNTIME_ERROR]JdbcExecutorException: JDBC executor sql has error: | CAUSED BY: PSQLException: [] ERROR: syntax error at or near ""contract_60000007""
???18 | CAUSED BY: GaussDatabaseException: syntax error at or near ""epms_contract_tu_60000007""