如题
Doris版本：2.1.7
Catalog参数
CREATE CATALOG jdbc_mysql_dim PROPERTIES (
"user" = "rt_admin",
"type" = "jdbc",
"password" = "xxxxx",
"jdbc_url" = "jdbc:mysql://xxxxxxx/dim?useUnicode=true&characterEncoding=utf8mb4&allowMultiQueries=true&useSSL=false&yearIsDateType=false&tinyInt1isBit=false&rewriteBatchedStatements=true",
"driver_url" = "mysql-connector-j-8.0.33.jar",
"driver_class" = "com.mysql.cj.jdbc.Driver"
);
SQL:
SELECT COLUMN_NAME as columnName,DATA_TYPE as columnType,ORDINAL_POSITION , COLUMN_KEY,CHARACTER_MAXIMUM_LENGTH,NUMERIC_PRECISION
from jdbc_mysql_dim.information_schema.COLUMNS
Doris查询结果
mysql查询结果
