starrocks外部表-mysql

最新推荐文章于 2024-05-04 02:31:08 发布

重生之我是一名程序员

最新推荐文章于 2024-05-04 02:31:08 发布

阅读量543

点赞数

分类专栏： flink 文章标签： flink

本文链接：https://blog.csdn.net/u013887008/article/details/131652469

版权

flink 专栏收录该内容

10 篇文章 0 订阅

订阅专栏

starrocks外部表-mysql

在mysql中创建表 t_user

CREATE TABLE `t_user` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `age` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

插入数据:
INSERT INTO `t_user` (`id`, `user_name`, `age`) VALUES (1, 'hello', 123);

在starrocks中创建外部表

CREATE EXTERNAL TABLE `t_user_sink` (
  `id` bigint NOT NULL,
  `user_name` varchar(255) DEFAULT NULL,
  `age` int DEFAULT NULL
)
ENGINE=mysql
PROPERTIES
(
    "host" = "172.1xx.x.x",
    "port" = "3306",
    "user" = "root",
    "password" = "root",
    "database" = "test",
    "table" = "t_user"
);

查询 starrocks:

mysql> select * from t_user_sink;
+------+-----------+------+
| id   | user_name | age  |
+------+-----------+------+
|    1 | hello     |  123 |
+------+-----------+------+
1 row in set (0.02 sec)