[
https://issues.apache.org/jira/browse/IOTDB-5066?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17697671#comment-17697671
]
Qingxin Feng commented on IOTDB-5066:
-------------------------------------
!image-2023-03-08-09-38-49-106.png|width=1215,height=583!
SQL语句中seriesSlotId（timeSlotId）从何处获取？是否和SeriesSlotNum一致？或者是否支持SeriesSlotNum
> 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
>
>
> 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)
