环境

lakesoul： v2.6.2
flink： v1.20.1
doris： v3.0.3

lakeoul cdc 表结构

mysql> show create table titles;
+--------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table  | Create Table                                                                                                                                                                                   |
+--------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| titles | CREATE TABLE `titles` (
  `rowKinds` text NOT NULL,
  `emp_no` int NOT NULL,
  `title` text NOT NULL,
  `from_date` datev2 NOT NULL,
  `to_date` datev2 NULL
) ENGINE=LAKESOUl_EXTERNAL_TABLE;

查询报错

mysql> select * from titles;
ERROR 1105 (HY000): errCode = 2, detailMessage = Unsupported tableType LAKESOUl_EXTERNAL_TABLE

具体错误

Unsupported tableType LAKESOUl_EXTERNAL_TABLE

完整触发流程

确实是使用catalogs

mysql> show catalogs;
+-----------+-------------+----------+-----------+-------------------------------+---------------------+------------------------+
| CatalogId | CatalogName | Type     | IsCurrent | CreateTime                    | LastUpdateTime      | Comment                |
+-----------+-------------+----------+-----------+-------------------------------+---------------------+------------------------+
|         0 | internal    | internal | Yes       | NULL                          | NULL                | Doris internal catalog |
|     10098 | lakesoul    | lakesoul | No        | 2025-04-23 07:48:54.631106279 | 2025-04-23 07:48:59 |                        |
+-----------+-------------+----------+-----------+-------------------------------+---------------------+------------------------+
2 rows in set (0.01 sec)
mysql> use `lakesoul`.`employees`;
Database changed
mysql> show tables;
+---------------------+
| Tables_in_employees |
+---------------------+
| departments         |
| dept_emp            |
| dept_manager        |
| employees           |
| salaries            |
| titles              |
+---------------------+
6 rows in set (0.02 sec)
mysql> show create table departments;
+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| Table       | Create Table                                                                                                                                      |
+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
| departments | CREATE TABLE `departments` (
  `rowKinds` text NOT NULL,
  `dept_no` text NOT NULL,
  `dept_name` text NOT NULL
) ENGINE=LAKESOUl_EXTERNAL_TABLE; |
+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)
mysql> select * from departments;
ERROR 1105 (HY000): errCode = 2, detailMessage = Unsupported tableType LAKESOUl_EXTERNAL_TABLE