CREATE EXTERNAL TABLE doris_1
(
序号
bigint NOT NULL,
姓名
varchar(255) NULL,
分数
double NULL
) ENGINE=JDBC
PROPERTIES (
"resource"="jdbc_resource_mysql80",
"table"="成绩",
"table_type"="mysql"
);
报错
Execution failed: Error Failed to execute sql: java.sql.SQLSyntaxErrorException: (conn=129) errCode = 2, detailMessage = Incorrect column name '序号'. Column regex is '^[a-zA-Z@0-9\s/][.a-zA-Z0-9+-/?@#$%^&*"\s,:]{0,255}$'