【已解决】doris上建mysql外表遇到的问题

Viewed 93
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我测试过能正常连,就是查表的时候总是报这个错

1 Answers