[jira] [Commented] (IOTDB-432) Add a new query for time interval

["Xiangdong Huang (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IOTDB-432?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17019307#comment-17019307 ] 

Xiangdong Huang commented on IOTDB-432:
---------------------------------------

Hi, academically, it is called as time series segmentation.

and this is a rule based segmentation.

+1 to introduce it into IoTDB. 

We can discuss about the SQL syntax  and return data format in detail.

 

> Add a new query for time interval
> ---------------------------------
>
>                 Key: IOTDB-432
>                 URL: https://issues.apache.org/jira/browse/IOTDB-432
>             Project: Apache IoTDB
>          Issue Type: New Feature
>            Reporter: atoildw
>            Priority: Major
>
> In some business scenarios, the time interval is used as a field that makes business sense, such as:
> In the reporting of vehicle data, if there is still no data report after 15 minutes, the vehicle should be in the flameout state, so it should be the end of a journey.
> I understand that currently there is no syntax in iotdb that can filter the interval, but I think it is necessary to implement it.
>  
> select s1 from root.d1 segment by interval >15s
> return endpoint/segments
>  
> {code:java}
> data:
> 1 2 3 29 30 31 32 48 49 
> endpoint like:
> [3,29] [32,48]
> segments like:
> [1,2,3] [29,30,31,32] [48,49] {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)