[ https://issues.apache.org/jira/browse/IOTDB-5066?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17697676#comment-17697676 ]
Qingxin Feng commented on IOTDB-5066: ------------------------------------- !image-2023-03-08-09-49-45-482.png! > 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 > > > 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)