You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@iotdb.apache.org by "Jialin Qiao (Jira)" <ji...@apache.org> on 2020/03/03 01:22:00 UTC
[jira] [Closed] (IOTDB-529) Relative times and NOW() operator
cannot be used in Group By
[ https://issues.apache.org/jira/browse/IOTDB-529?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jialin Qiao closed IOTDB-529.
-----------------------------
Fix Version/s: 0.10.0-SNAPSHOT
Resolution: Fixed
> Relative times and NOW() operator cannot be used in Group By
> ------------------------------------------------------------
>
> Key: IOTDB-529
> URL: https://issues.apache.org/jira/browse/IOTDB-529
> Project: Apache IoTDB
> Issue Type: Bug
> Components: Core/Engine, Planner/SQLParser
> Reporter: Julian Feinauer
> Assignee: Haonan Hou
> Priority: Major
> Labels: pull-request-available
> Fix For: 0.10.0-SNAPSHOT
>
> Time Spent: 20m
> Remaining Estimate: 0h
>
> When doing a group by query it is only possible to give absolute timestamps for the group by window.
> One woudl expect the following query to be valid
> {code:java}
> select min_value(counter), avg(counter), max_value(counter), count(counter) from root.fabrik1.linie01.steuerung01 GROUP BY (1m, [NOW()-1h,NOW()]);
> {code}
> but it is not.
> {color:#6a8759} {color}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)