MySQL端:
CREATE TABLE doris_test
(
id
int(11) NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
insert into doris_test VALUES(null);
Doris端:
CREATE CATALOG jdbc_mysql
PROPERTIES (
"user" = "test",
"use_meta_cache" = "false",
"type" = "jdbc",
"password" = "XXXX",
"jdbc_url" = "jdbc:mysql://XXXX:3306/XXX?yearIsDateType=false&tinyInt1isBit=false&transformedBitIsBoolean=true&useUnicode=true&rewriteBatchedStatements=true&characterEncoding=utf-8",
"driver_url" = "mysql-connector-java-5.1.47.jar",
"driver_class" = "com.mysql.jdbc.Driver"
);