catalog多库union all 报错 ，V2.1.5版本

Viewed 29
2.1

catalog单独执行查询都可以正常查询

image.png
image.png

一旦使用union all来将多个查询结果合并到一起就会出现异常
image.png

____3
2 Answers

【问题处理】跟进中，有进展会更新回帖

黄海军@SelectDB1956

补充下最新信息：发现是创建catalog的时候如果都指定了use_meta_cache为true会出现这个异常，如果union all中的表大于一张指定use_meta_cache为true则会出现。创建catalog语句如下：
CREATE CATALOG mysql_uk PROPERTIES (
"user" = "advert_cdc",
"use_meta_cache" = "true",
"type" = "jdbc",
"password" = "",
"jdbc_url" = "jdbc:mysql://node1:3306?zeroDateTimeBehavior=convertToNull&yearIsDateType=false&tinyInt1isBit=false&useUnicode=true&rewriteBatchedStatements=true&characterEncoding=utf-8",
"driver_url" = "file:///opt/datasophon/doris/be/lib/mysql-connector-j-8.3.0.jar",
"driver_class" = "com.mysql.cj.jdbc.Driver"
);

CREATE CATALOG mysql_us PROPERTIES (
"user" = "advert_cdc",
"use_meta_cache" = "true",
"type" = "jdbc",
"password" = "*XXX",
"jdbc_url" = "jdbc:mysql://node2:3306?zeroDateTimeBehavior=convertToNull&yearIsDateType=false&tinyInt1isBit=false&useUnicode=true&rewriteBatchedStatements=true&characterEncoding=utf-8",
"driver_url" = "file:///opt/datasophon/doris/be/lib/mysql-connector-j-8.3.0.jar",
"driver_class" = "com.mysql.cj.jdbc.Driver"
);

____3