1.基本维护命令
1.查看前端节点
SHOW PROC '/frontends'
2.查看后端节点
SHOW PROC '/backends'
3.查看表数据大小
SHOW DATA # 查看所有表大小
SHOW DATA FROM org_project_data_2 # 查看指定表大小
5.查看表分区
SHOW PARTITIONS FROM new_table_name
6.查看load数据的lable的任务执行情况
SHOW LOAD WHERE label="my_label1"
7.重命名表
ALTER TABLE test_table RENAME new_table_name
2.导数据到另一个表
1.创建目标表
2.在目标表创建好要导入数据的分区(如果不创建好分区,数据导入会因为没有分区而失败)
ALTER TABLE test_table SET ("dynamic_partition.enable" = "false");
ALTER TABLE test_table ADD PARTITION p202108 VALUES [("2021-08-01"), ("2021-09-01"));
ALTER TABLE test_table ADD PARTITION p202109 VALUES [("2021-09-01"), ("2021-10-01"));
ALTER TABLE test_table ADD PARTITION p202110 VALUES [("2021-10-01"), ("2021-11-01"));
ALTER TABLE test_table ADD PARTITION p202111 VALUES [("2021-11-01"), ("2021-12-01"));
ALTER TABLE test_table SET ("dynamic_partition.enable" = "true");
3.向目标表导入数据
INSERT INTO test_table WITH label my_label3
WITH cte1 AS (SELECT * FROM `esn_assemble_history_5`), cte2 AS (SELECT * FROM `org_project_data_5`)
SELECT cte1.esn,cte1.engine_start,cte2.progno,cte2.load_date,cte2.pistonDisplacement1,cte2.pistonDisplacement2,cte2.pistonDisplacement3,cte2.pistonDisplacement4,cte2.pistonDisplacement5,cte2.pistonDisplacement6,cte2.torque,cte2.angle,cte2.time FROM cte1 JOIN cte2 WHERE cte1.esn=cte2.esn AND SUBSTRING(cte1.engine_start,1,19)=SUBSTRING(cte2.engine_start,1,19)