[ 
https://issues.apache.org/jira/browse/IOTDB-530?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17048594#comment-17048594
 ] 

Xiangdong Huang commented on IOTDB-530:
---------------------------------------

Hm, I read the source code on the master. The group by syntax is changed and 
now it only supports the start time and end time [1]. And notice that the time 
interval is like: [start, end), which means the end time is excluded.

 

[1] [http://iotdb.apache.org/#/Documents/0.9.x/chap5/sec2]

 

v0.9 uses antlr3. let me see whether I can fix it...

 

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

Reply via email to