doris:4.1.0-apache
oceanbase: 5.7.25-OceanBase-v4.2.5.6
oceanbase-jar：oceanbase-client-2.4.18.jar
$path: $doris_home/be/jdbc_drivers, $doris_home/fe/jdbc_drivers
question: type UNSUPPORTED is unsupported for Nereids
前置处理：
ocenabase: create table test.test(id int, name varchar(100));
doris:
create catalog test_catalog_ob properties(
"type" = 'jdbc',
"user" = "root",
"password" = "root",
"jdbc_url"="jdbc:oceanbase://localhost:2883/test?xxx"
"driver_url" = "ocenabase-client-2.4.18.jar",
"driver_class" = "com.oceanbase.jdbc.Driver"
)
操作处理：
show database from test_catalog_ob; #可以查出
show tables from test_catalog_ob.test; #可以查出
select * from test_catalog_ob.test.test; # 报错
错误信息：
SQL Error [1105] [HY000]: errCode =2, detailMessage= type UNSUPPORTED is unsupported for Nereids
修正处理： set enable_nereids_planner = true;
set enable_fallback_to_original_planner = true;
继续查： select * from test_catalog_ob.test.test; # 报错
继续如下操作： desc test_catalog_ob.test.test;
发现 type: unkonwn type: UNSUPPORTED_TYPE
