回复: Add SQL create data/schema region

[Zhou Yifu <ef...@outlook.com>]

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<ma...@qq.com.INVALID>
发送时间: 2022年8月18日 10:50
收件人: dev<ma...@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