ong-124 opened a new issue, #51630: URL: https://github.com/apache/doris/issues/51630
### Search before asking - [x] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version # 环境版本 > **系统**: ubuntu 22.04 > **Kubenertes**: v1.32.3 > **doris**: v3.0.5 > **flink**: v1.20.1 > **lakesoul**: v2.6.2 ### What's Wrong? 我在尝试湖仓一体案例《使用 Doris 和 LakeSoul》时遇到了`Unsupported tableType LAKESOUl_EXTERNAL_TABLE`错误。在`flink CDC`结束后，可以在`flink sql`查询到入湖的数据，但是在doris创建catalog后，查询提示不支持的类型。 ### What You Expected? 如何才能正常查询呢？是我的用法有问题还是doris不能查询入湖数据。有没有解决办法呢？ ### How to Reproduce? ```sql mysql> CREATE CATALOG `lakesoul` PROPERTIES ( 'type'='lakesoul', 'lakesoul.pg.username'='postgres', 'lakesoul.pg.password'='gzdx', 'lakesoul.pg.url'='jdbc:postgresql://10.10.100.102:5432/lakesoul?stringtype=unspecified&sslmode=disable', 's3.endpoint'='http://10.10.100.103:9000', 's3.access_key'='ogJ6mq1xiH4cKB6tbpRo', 's3.secret_key'='XzY6ayn1LQ8UIyYRIP9bgr3YoorvSBuRH43Z8Aji' ); mysql> show catalogs; +---------------+-------------+----------+-----------+-------------------------------+----------------+------------------------+ | CatalogId | CatalogName | Type | IsCurrent | CreateTime | LastUpdateTime | Comment | +---------------+-------------+----------+-----------+-------------------------------+----------------+------------------------+ | 0 | internal | internal | Yes | NULL | NULL | Doris internal catalog | | 1749618424826 | lakesoul | lakesoul | No | 2025-06-11 05:16:10.254044212 | NULL | | +---------------+-------------+----------+-----------+-------------------------------+----------------+------------------------+ 2 rows in set (0.00 sec) mysql> use `lakesoul`.`employees`; Database changed mysql> show databases; +--------------------+ | Database | +--------------------+ | default | | employees | | information_schema | | mysql | +--------------------+ 4 rows in set (0.01 sec) mysql> show tables; +---------------------+ | Tables_in_employees | +---------------------+ | departments | | dept_emp | | dept_manager | | employees | | salaries | | titles | +---------------------+ 6 rows in set (0.02 sec) mysql> select * from titles; ERROR 1105 (HY000): errCode = 2, detailMessage = Unsupported tableType LAKESOUl_EXTERNAL_TABLE ``` ### Anything Else? 记得在v3.0.4反馈过这个问题。工程师反馈是doris bug，并表示会在下一个小版本修复。不过看来在v3.0.5版本并未修复。 ### Are you willing to submit PR? - [x] Yes I am willing to submit a PR! ### Code of Conduct - [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
