Fluss使用

一、常用命令

1、创建数据库

CREATE DATABASE `fluss`.`test_db`;

2、删除数据库

DROP DATABASE `fluss`.`test_db`;

删除数据库及其中所有表

DROP DATABASE `fluss`.`test_db` CASCADE;

3、创建主键表

CREATE TABLE `fluss`.`test_db`.`test_wangshida` (
  shop_id BIGINT,
  user_id BIGINT,
  num_orders INT,
  total_amount INT,
  PRIMARY KEY (shop_id, user_id) NOT ENFORCED
) WITH (
  'bucket.num' = '4'
);

4、删除表

DROP TABLE `fluss`.`test_db`.`test_wangshida`; 

5、写入数据

# 写入部分列
INSERT INTO `fluss-catalog`.`my_db`.`my_pk_tbl` (shop_id, user_id, num_orders)
SELECT shop_id, user_id, num_orders FROM source;

# 写入全部列
INSERT INTO `fluss-catalog`.`my_db`.`my_pk_tbl`
SELECT * FROM source;

6、更新数据

UPDATE `my-catalog`.`my_db`.`my_pk_tbl` SET total_amount = 2 WHERE shop_id = 10000 and user_id = 123456;

7、删除数据

DELETE FROM `my-catalog`.`my_db`.`my_pk_tbl` WHERE shop_id = 10000 and user_id = 123456;

8、创建同步表

CREATE TEMPORARY TABLE `fluss`.`test_db`.`ods_db_statistics_compass_event_rt` (
  `id` int COMMENT '主键',
  `event_id` varchar(32) COMMENT '页面或事件ID',
  `name` varchar(95) COMMENT '事件名称'
) COMMENT '描述'
WITH (
  'connector' = 'mysql',
	'hostname' = '',
	'username' = '',
	'password' = '',
	'database-name' = '',
	'table-name' = 'compass_event'
);

 

二、 参考文档

1、阿里云

https://help.aliyun.com/zh/flink/realtime-fluss/user-guide/manage-fluss-databases?spm=a2c4g.11186623.help-menu-45029.d_1_3_1.662c7307IV3K8I