[ https://issues.apache.org/jira/browse/IOTDB-530?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17048607#comment-17048607 ]
Xiangdong Huang commented on IOTDB-530: --------------------------------------- Hi, 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] It seems your first TimeZone should be "+01:00", please have a try. > 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 > Priority: Major > > 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)