Doris创建外部表打开报错
0smileyear 发布于2021-06-28 浏览:993 回复:10
0
收藏

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
个赞
共10条回复 最后由429385304回复于2021-07-27
#11429385304回复于2021-07-27

io.grpc.StatusRuntimeException: UNAVAILABLE: Network closed for unknown reason

0
#10429385304回复于2021-07-27

Network closed for unknown reason

0
#95153381回复于2021-06-29

太高大上了~

0
#80smileyear回复于2021-06-28

已经解决,之前没有接触过odbc,以为解压就可以,后续使用yum安装后解决,感谢各位大佬

0
#7O国殇O回复于2021-06-28

不懂帮顶

0
#6Ling缪回复于2021-06-28

你改完 配置后重启过be 嘛?还有一点是,是否存在权限之类的问题?

0
#50smileyear回复于2021-06-28

版本号0.14.2

0
#40smileyear回复于2021-06-28

0
#30smileyear回复于2021-06-28

0
#20smileyear回复于2021-06-28

一开始是路径下没有libmyodbc5w,我按照网上下载驱动包解压到指定目录后,修改odbcinst.ini里面的路径后依旧不行(三台机子都改了 并重启了)

0
快速回复
TOP
切换版块