CREATE EXTERNAL RESOURCE "mysql_resource"
PROPERTIES (
"type" = "odbc_catalog",
"user" = "dba",
"password" = "123456",
"host" = "192.168.1.13",
"port" = "3306",
"odbc_type" = "mysql",
"driver" = "MySQL ODBC 5.3 Unicode Driver"
);
CREATE EXTERNAL TABLE `doris_test` (
`id` INT NOT NULL
) ENGINE=ODBC
COMMENT "ODBC"
PROPERTIES (
"odbc_catalog_resource" = "mysql_resource",
"database" = "anal_db",
"table" = "doris_test"
);
SELECT * FROM doris_test
> 1105 - errCode = 2, detailMessage = (192.168.1.87)[INTERNAL_ERROR]Unsupported exec type in pipelineX: ODBC_SCAN_NODE
> 时间: 0.029s
查询表总是报这个错,请大佬们帮忙看下是怎么回事?
doris 版本是:apache-doris-2.1.0-bin-x64.tar.gz
按官网提供mysql建外部表的脚本会提示要加驱动driver ,odbc_type,
ODBC我测试过能正常连,就是查表的时候总是报这个错