1105 - RuntimeException, msg: org.apache.doris.common.UserException: errCode = 2, detailMessage = java.lang.RuntimeException:
Conflict table names found in remote database/schema: xx when lower_case_table_names is 1: [xx, xx]. Please use meta_name_mapping to specify the names.
at org.apache.doris.datasource.mapping.IdentifierMapping.setTableNameMapping(IdentifierMapping.java:111)
at org.apache.doris.datasource.jdbc.client.JdbcClient.filterTableNames(JdbcClient.j
catalog查询报错，版本2.1.2
Viewed 26
2 Answers
你配置了大小写不敏感，但是源库中有名称一样，但是大小写不同的库名
参考 https://doris.apache.org/zh-CN/docs/lakehouse/database/jdbc#%E5%B0%8F%E5%86%99%E5%90%8D%E7%A7%B0%E5%90%8C%E6%AD%A5 进行配置
已解决；类似问题可以参考 ALTER CATALOG xxx SET PROPERTIES ('meta_names_mapping' = '{
"tables": [
{
"remoteDatabase": "xx",
"remoteTable": "table_name",
"mapping": "table_name_1"
}
]
}');