You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@iotdb.apache.org by "Qingxin Feng (Jira)" <ji...@apache.org> on 2023/03/08 01:41:00 UTC

[jira] [Commented] (IOTDB-5066) Perfect the implementation of Getslots

    [ 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)