在不修改原表的前提下,如何使用jdbc连接中文的mysql外表,求求了

Viewed 4

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}$'

0 Answers