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