Doris创建外部表打开报错[unixODBC][Driver Manager]Can't open lib '/data/mysql-connector-odbc-5.3.12-linux-glibc2.12-x86-64bit/lib/libmyodbc5w.so' : file not found (0)
建表语句如下
CREATE EXTERNAL RESOURCE `hadoopmysql`
PROPERTIES (
"type" = "odbc_catalog",
"host" = "****",
"port" = "3306",
"user" = "root",
"password" = "***",
"database" = "test",
"odbc_type" = "mysql",
"driver" = "MySQL ODBC 8.0 Unicode Driver"
);
CREATE EXTERNAL TABLE `test06282` (
`k1` decimal(9, 3) NOT NULL COMMENT "",
`k2` char(10) NOT NULL COMMENT "",
`k3` datetime NOT NULL COMMENT "",
`k5` varchar(20) NOT NULL COMMENT "",
`k6` double NOT NULL COMMENT ""
) ENGINE=ODBC
COMMENT "ODBC"
PROPERTIES (
"odbc_catalog_resource" = "hadoopmysql",
"database" = "test",
"table" = "test0628"
);
收藏
点赞
0
个赞
请登录后评论
TOP
切换版块
我也是这个报错 请问你解决了吗
io.grpc.StatusRuntimeException: UNAVAILABLE: Network closed for unknown reason
Network closed for unknown reason
太高大上了~
已经解决,之前没有接触过odbc,以为解压就可以,后续使用yum安装后解决,感谢各位大佬
不懂帮顶
你改完 配置后重启过be 嘛?还有一点是,是否存在权限之类的问题?
版本号0.14.2
一开始是路径下没有libmyodbc5w,我按照网上下载驱动包解压到指定目录后,修改odbcinst.ini里面的路径后依旧不行(三台机子都改了 并重启了)