1.2.7升级到2.0.10 查询Catalog报错NumberFormatException, msg: null

Viewed 77

版本:2.0.10

升级之前执行ok,升级之后报错如下
image.png

fe日志
image.png

升级之前创建的catalog

CREATE EXTERNAL RESOURCE ad_resource PROPERTIES (
   "type" = "jdbc",
   "user" = "root",
   "password" = "xxx",
   "jdbc_url" = "jdbc:mysql://xxx:3306/ad?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&yearIsDateType=false&tinyInt1isBit=true&transformedBitIsBoolean=true",
   "driver_url" = "mysql-connector-java-5.1.49.jar",
   "driver_class" = "com.mysql.jdbc.Driver"
);

CREATE CATALOG mysql_ad WITH RESOURCE ad_resource;

1 Answers

大佬,我们获取几个信息哈:

  1. 贴下详细的报错信息,在fe.log中找下
  2. mysql calalog的创建语句
  3. mysql driver的驱动版本

回帖:
建议走catalog的方式,不建议用走外表的方式了