回复: Add SQL create data/schema region

[Zhou Yifu]

Hi,

I am confused about why our current algorithm cannot expand RegionGroup 
automatically and had to add region manually by DBA? Is it possible to set a  
threshold when SeriesPartitionSlot is coming filled and execute the logic you 
create a region automatically?

Thanks,
Yifu Zhou

从 Windows 版邮件<https://go.microsoft.com/fwlink/?LinkId=550986>发送

发件人: Yongzao Dan<mailto:532741...@qq.com.INVALID>
发送时间: 2022年8月18日 10:50
收件人: dev<mailto:dev@iotdb.apache.org>
主题: Add SQL create data/schema region

Hi,
&nbsp; I'm planning to add a SQL for IoTDB cluster version. Here are the 
details of this SQL:


&nbsp; Motivation:&nbsp;We don't have enough evidence to design an 
optimal&nbsp;RegionGroup&nbsp;expansion algorithm yet.&nbsp;
If a large number of devices are created in a StorageGroup and the 
SeriesPartitionSlot is filled, the current algorithm cannot 
expand&nbsp;RegionGroup&nbsp;anymore.&nbsp;
Therefore, we need a special SQL to enable DBA 
expand&nbsp;RegionGroup&nbsp;manually.


&nbsp; Syntax Definition: create (data | schema) region on prefixPath(Represent 
a specific StorageGroup)


&nbsp; Function Definition: Create a new data/schema RegionGroup for the 
specific StorageGroup.


------------------------------------------------------------------------------------------------------------


Yongzao Dan,
School of Software, Tsinghua University