mysql外部表创建出错

【详述】建mysql外部表
【背景】建立mysql外部表
【StarRocks版本】2.0.1
【集群规模】3fe（3 follower）+3be（fe与be混部）
【机器信息】CPU虚拟核/内存/网卡，28C/256G/双百兆
【附件】

• fe.warn.log
  

  图片996×594 42.1 KB

-工具执行报错

图片726×451 28.4 KB

• 并行度：show variables like ‘%parallel_fragment_exec_instance_num%’; 1
• cbo是否开启：show variables like ‘%cbo%’; ture
• be节点cpu和内存使用率截图
  

请提供下建表sql，另外提供下wget --user=root --password=1234 --post-file post_file http://fe_host:fe_http_port/api/query_dump?db=tpch -O dump_file结果，post_file是建表sql文件，需要替换用户名、密码和数据库。

• 建表语句
  CREATE EXTERNAL TABLE t_enterprise_0
  (
  eid String default ‘’,
  id bigInt default ‘’,
  reg_no String default ‘’ ,
  credit_no String default ‘’ ,
  org_no String default ‘’ ,
  name String default ‘’ ,
  format_name String default ‘’ comment ‘格式化公司名’,
  category String default ‘’ ,
  province String default ‘’ ,
  econ_kind String default ‘’ ,
  regist_capi String default ‘’ ,
  actual_capi String default ‘’ ,
  scope String default ‘’ ,
  term_start String default ‘’ ,
  term_end String default ‘’ ,
  check_date String default ‘’ ,
  belong_org String default ‘’ ,
  oper_name String default ‘’ ,
  oper_type String default ‘’ ,
  oper_name_id String default ‘’ ,
  start_date String default ‘’ ,
  end_date String default ‘’ ,
  status String default ‘’ ,
  address String default ‘’ ,
  type Int default ‘’ ,
  type_desc String default ‘’ ,
  title String default ‘’ ,
  longitude double default ‘’ ,
  latitude double default ‘’ ,
  gd_longitude double default ‘’ ,
  gd_latitude double default ‘’ ,
  obj_id String default ‘’ ,
  source String default ‘’ ,
  tax_no String default ‘’ ,
  collegues_num String default ‘’ ,
  description String default ‘’ ,
  created_time BigInt default ‘’ ,
  last_update_time BigInt default ‘’ ,
  logo_url String default ‘’ ,
  status_code String default ‘’ ,
  econ_type String default ‘’ ,
  department String default ‘’ ,
  url String default ‘’ ,
  org_type String default ‘’ ,
  row_update_time datetime default ‘’,
  province_code String default ‘’ ,
  district_code String default ‘’ ,
  title_code String default ‘’ ,
  econ_kind_code String default ‘’ ,
  regist_capi_new decimal(40, 6) ,
  currency_unit String default ‘’ ,
  belong_org_code String default ‘’ ,
  credit_area_code String default ‘’ ,
  revoke_reason String default ‘’ comment ‘吊销原因’,
  revoke_date String default ‘’ ,
  logout_reason String default ‘’ comment ‘注销原因’,
  logout_date String default ‘’ ,
  group_name String default ‘’ ,
  group_abbreviation String default ‘’ ,
  revoked_certificates String default ‘’ ,
  new_status_code String default ‘’ ,
  type_new String default ‘’ comment ‘类别（新）’,
  category_new String default ‘’ comment ‘企业分类’,
  local_row_update_time datetime default ‘’
  )
  ENGINE=mysql
  PROPERTIES
  (
  “host” = “172.16.42.31”,
  “port” = “3306”,
  “user” = “root”,
  “password” = “1234”,
  “database” = “db_enterprise_0”,
  “table” = “t_enterprise_0”
  );

这个请求404
http端口是8030，页面可以正常访问

用户名、密码和db=tpch换了嘛

换了，数据库密码还有库名

把执行的命令和结果截图发下

decimal 超出支持的范围了

starrocks decimal最大支持38位，可以改为decimal(38,6)