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:27:00 UTC
[jira] [Created] (IOTDB-530) GROUP BY does not allow timezone
information in 2nd Parameter
Julian Feinauer created IOTDB-530:
-------------------------------------
Summary: GROUP BY does not allow timezone information in 2nd Parameter
Key: IOTDB-530
URL: https://issues.apache.org/jira/browse/IOTDB-530
Project: Apache IoTDB
Issue Type: Bug
Components: Planner/SQLParser
Reporter: Julian Feinauer
I tried to issue the following command:
{code:java}
select avg(counter), count(counter) from root.fabrik1.linie01.steuerung01 group by (1d, 2020-01-01T00:00:00+1:00, [2020-01-01T00:00:00+01:00, 2020-03-01T23:59:00+01:00]{code}
where I wanted to use the 2nd Paramter in Group By in my timezone (for the 3rd parameter it works), but it fails and tells me that I can only enter date (without Timezone).
So instead I have to do smth like
{code:java}
select avg(counter), count(counter) from root.fabrik1.linie01.steuerung01 group by (1d, 2019-12-31T17:00:00, [2020-01-01T00:00:00+01:00, 2020-03-01T23:59:00+01:00])
{code}
which is rather ugly.
So the fix would be to allow also to enter the 2nd Parameter as time + offset.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)