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