【详述】StarRocks上有一MySQL类型的外部表，MySQL表新增了一个字段，无法同步到StarRocks。
-
尝试使用 ALTER TABLE t_mysql_k_info ADD COLUMN name varchar(64) DEFAULT ‘system’ COMMENT ‘名称’ AFTER id; 报错：Unexpected exception: Do not support alter non-native table/materialized-view[t_mysql_k_info]
-
尝试使用 REFRESH EXTERNAL TABLE t_mysql_k_info; 报错：Unexpected exception: table : t_mysql_k_info not exists, or is not hive/hudi external table/view
表结构示例如下：
CREATE EXTERNAL TABLE t_mysql_k_info (
id bigint(20) NULL COMMENT “”,
creator varchar(32) NULL COMMENT “”
) ENGINE=MYSQL
PROPERTIES (
“host” = “1.1.1.1”,
“port” = “3306”,
“user” = “root”,
“password” = “”,
“database” = “a”,
“table” = “k_info”
);
【StarRocks版本】例如：3.1.9