drop table if exists mysql_factfinance;
CREATE EXTERNAL TABLE mysql_factfinance
(
DateKey INT,
Amount double,
Date date
)
ENGINE=ODBC
PROPERTIES
(
"host" = "192.168.xx.xx",
"port" = "3306",
"user" = "root",
"password" = "root123",
"database" = "test",
"table" = "factfinance",
"driver" = "MySQL ODBC 8.0 Unicode Driver",
"odbc_type" = "mysql"
);
更多文章请扫码关注公众号,有问题的小伙伴也可以在公众号上提出。