[
https://issues.apache.org/jira/browse/IOTDB-5066?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17697763#comment-17697763
]
陈哲涵 commented on IOTDB-5066:
----------------------------
这里的 show data regions 和 show regionid 本身是两个sql。。。前者里面的 SlotNum
指的是每个region里面的槽个数，后者的 id 指的是根据这两个 id 来找对应的 region。比如 SeriesSlotNum 为 4，可能这 4 个的
id 分别是 1933,1241,1432,1434 这样的
> Perfect the implementation of Getslots
> --------------------------------------
>
> Key: IOTDB-5066
> URL: https://issues.apache.org/jira/browse/IOTDB-5066
> Project: Apache IoTDB
> Issue Type: Improvement
> Reporter: Gaofei Cao
> Assignee: 陈哲涵
> Priority: Minor
> Labels: pull-request-available
> Attachments: image-2023-03-08-09-38-49-106.png,
> image-2023-03-08-09-49-45-482.png, image-2023-03-08-09-50-08-396.png
>
>
> 1. add query sql using timestamp。 `show Data RegionId of root.test.g_1 where
> seriesSlotId=4468 and timestamp=1536796800012`。 timestamp can be any value,
> we should calculate the timeslot of given timestamp
>
> 2. can show region of given deviceId. `show Data RegionId of root.test.g_1
> where seriesSlotId=4468` => `show Data RegionId of root.test.g_1 where
> deviceId=root.tesst.g_1`
>
> 3. timeslotId = timestamp % time_partition_interval. The query sql used
> timestamp as timeslotId now.
>
> 4. The show slot id should be in order.
>
> 5. modify user doc
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
