You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "sunjincheng (Jira)" <ji...@apache.org> on 2021/03/29 09:00:00 UTC

[jira] [Commented] (IOTDB-1143) continuous query

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

sunjincheng commented on IOTDB-1143:
------------------------------------

Thanks for your proposal [~songbinghua]! CQ is nice feature for IoTDB,would be great if there is any detail design  to share? 

> continuous query
> ----------------
>
>                 Key: IOTDB-1143
>                 URL: https://issues.apache.org/jira/browse/IOTDB-1143
>             Project: Apache IoTDB
>          Issue Type: New Feature
>          Components: Core/Engine
>            Reporter: songbinghua
>            Assignee: songbinghua
>            Priority: Blocker
>
> Continuous Query is a very useful feature for users to query time series data periodically according to the time interval and time range.
> For example, using the continuous query described below, the IoTDB downsamples the CPU load metric, and keeps a single average datapoint per 15 minutes grouped by server region:
> CREATE CONTINUOUS QUERY "downsampled_cpu_load"
> ON database_name
> BEGIN
>   SELECT mean(value) as value,
>   INTO "downsampled.cpu_load"
>   FROM cpu_load
>   GROUP BY time(15m), region
> END
> However, the IoTDB does not yet support this feature,but the InfluxDB has supported this feature and many scenario need this feature eagerly. So we need to support  Continuous Query,and I would like to develop it. 



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