I created a table using Flink SQL on yarn session. CREATE TEMPORARY TABLE `scrm_admin_role` ( > `id` bigint, > `role_name` string, > `sort` int, > `type` tinyint, > `status` tinyint, > `tenant_id` bigint, > `deleted` BOOLEAN, > `create_time` TIMESTAMP, > `update_time` TIMESTAMP, > PRIMARY KEY (`id`) NOT ENFORCED > ) WITH ( > 'connector' = 'jdbc', > 'url'='jdbc:mysql://172.17.16.45:3306/willing_base', > 'username' = '*', > 'password' = *', > 'table-name' = 'scrm_admin_role' > );
The origin table is very small, about 10k lines. Then I tried to select to check the data, select * from scrm_admin_role limit 10; It can retrieve the result, but very slow, maybe took about 2~3 minutes. Cloud anyone tell me why and how cloud I make it fast. -- Best regards Sili Liu