Doris常用命令 - 分布式数据库

##创建用户并授权
	create user 'vosuser'@'172.16.%.%' identified by 'xxxxxxxxxxxxx';
	GRANT ALL  ON vos.* TO 'vosuser'@'172.16.%.%';
	
	#查询权限
	GRANT SELECT_PRIV ON vos.* TO 'vosuser'@'172.16.%.%';

##设置表的默认副本数（仅影响后续新建分区）
#####如果希望后续新增分区自动使用新的副本数，但不修改现有分区的副本数，请改用 default.replication_num：

ALTER TABLE ydx_call_record SET ("default.replication_num" = "2");

##修改现有分区的副本数
	ALTER TABLE ydx_call_record 
	MODIFY PARTITION (*) -- * 表示所有分区
	SET ("replication_num" = "1");

##修改为按副本均衡
	修改 fe.conf 配置文件： "tablet_rebalancer_type" = "partition"

##修改为按节点均衡（默认）
	修改 fe.conf 配置文件： "tablet_rebalancer_type" = "beload"

##查看表的分布情况（百分比）
	SHOW REPLICA DISTRIBUTION FROM ydx_call_record

##查看表的tablet情况
	SHOW TABLETS FROM ydx_call_record

##查看分区
	SHOW PARTITIONS from ydx_call_record
	SHOW PARTITIONS from ydx_call_record where partitionname like '%202406%'
	
---
##删除分区
####1. 临时禁用动态分区功能
	ALTER TABLE ydx_call_record SET ("dynamic_partition.enable" = "false");
####2. 手动删除目标分区
	ALTER TABLE ydx_call_record DROP PARTITION p_20240601;
####3. 重新启用动态分区功能（重要！）
	ALTER TABLE ydx_call_record SET ("dynamic_partition.enable" = "true");
	
---
##清空分区
	ALTER TABLE ydx_call_record TRUNCATE PARTITION p_20240601;
	TRUNCATE TABLE d9_vos_cdr PARTITION(p_20250501);
	
---
##添加bloom filter索引
	ALTER TABLE ydx_call_record SET ("bloom_filter_columns" = "phone,session_id,call_task_id,user_id")

---
##添加
	ALTER TABLE ydx_call_record ADD INDEX idx_phone (phone);
---
##查看索引进度
	SHOW ALTER TABLE COLUMN