wanqiang2046 opened a new issue, #32245: URL: https://github.com/apache/doris/issues/32245
### 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 2.1.0 ### What's Wrong? 用客户端或者sql查询之前的odbc外链表，全部报错，报错如下： Caused by: java.sql.SQLException: errCode = 2, detailMessage = (172.19.176.193)[INTERNAL_ERROR]Unsupported exec type in pipelineX: ODBC_SCAN_NODE 建表语句例子： CREATE EXTERNAL TABLE `dim_basic_ts_staff` ( `id` BIGINT NOT NULL COMMENT '主键', `code` VARCHAR(30) NOT NULL DEFAULT "" COMMENT '员工编号', `name` VARCHAR(100) NOT NULL DEFAULT "" COMMENT '员工名称', `belong_site` VARCHAR(64) NOT NULL DEFAULT "" COMMENT '网点编号', `belong_department` VARCHAR(64) NOT NULL DEFAULT "1" COMMENT '所属部门(运营部DT01,销售部DT02,IT部DT03,客服部DT04,财务部DT05)', `staff_type` VARCHAR(32) NOT NULL DEFAULT "1" COMMENT '员工类型（骑手ET01，操作员ET02，客服ET03，财务ET04，主管ET05，司机ET06）', `telephone` VARCHAR(32) NOT NULL DEFAULT "" COMMENT '手机号', `email` VARCHAR(50) NOT NULL DEFAULT "" COMMENT '邮箱', `sex` VARCHAR(32) NOT NULL DEFAULT "2" COMMENT '性别（0男,1女,2未知）', `induction_time` DATETIME NOT NULL COMMENT '入职日期', `address` VARCHAR(128) NOT NULL DEFAULT "" COMMENT '地址信息', `bank_account` VARCHAR(64) NOT NULL DEFAULT "" COMMENT '银行账号', `remark` VARCHAR(128) NOT NULL DEFAULT "" COMMENT '备注', `status` VARCHAR(32) NOT NULL DEFAULT "1" COMMENT '有效状态（0禁用，1启用）', `country_code` CHAR(2) NOT NULL DEFAULT "" COMMENT '所属国家二字码', `international_code` VARCHAR(8) NULL DEFAULT "" COMMENT '所属国家国际区号', `batch_operation_status` TINYINT NOT NULL DEFAULT "0" COMMENT '批量操作零担状态 0:否 1:是', `create_by` VARCHAR(64) NOT NULL DEFAULT "" COMMENT '创建者id', `create_time` DATETIME NOT NULL COMMENT '创建时间', `update_by` VARCHAR(64) NOT NULL DEFAULT "" COMMENT '更新者id', `update_time` DATETIME NOT NULL COMMENT '更新时间', `id_card` VARCHAR(64) NOT NULL DEFAULT "" COMMENT '员工身份证号码', `social_account` VARCHAR(64) NOT NULL DEFAULT "" COMMENT '员工社保帐号' ) ENGINE=ODBC COMMENT 'ODBC' PROPERTIES ( "host" = "***", "port" = "3306", "user" = "*****", "password" = "", "driver" = "MySQL ODBC 5.3 Unicode Driver", "odbc_type" = "mysql", "charest" = "utf8", "database" = "speedaf_cheetah_basic", "table" = "ts_staff" ); ### What You Expected? 希望2.1.0能继续支持odbc外链表，目前我们生产上面还有很多odbc外链表。 ### How to Reproduce? _No response_ ### Anything Else? _No response_ ### Are you willing to submit PR? - [ ] 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: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
