You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@iotdb.apache.org by "Julian Feinauer (Jira)" <ji...@apache.org> on 2020/03/01 13:08:00 UTC

[jira] [Created] (IOTDB-529) Relative times and NOW() operator cannot be used in Group By

Julian Feinauer created IOTDB-529:
-------------------------------------

             Summary: 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


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)